I have an application which generates in portal 1000 subportals. After this operation performance of Portal went down siginificantly. As I understand, its because of growing of dbase? Are there a chance to reduce these drops of performance on a single machine (I mean without clustering)? Maybe some dbase improvements? I see, installation of portal doesn't make indexes in database at all.
I'm using jboss 4.0.4 + portal 2.4.1 on windows, postgresql.

Thank you.