Search performance

[wgs]

My repository has about 300,000 files. When I use advanced search for searching a ducument, the response time is always 3-8 seconds for >1000 results. I think it is too long, under 1s is acceptable. How can I tuning performance in searching?
I use: Tomcat server (comes with Alfresco3.4d package), Alfresco 3.4d, MySQL (also PostgreSQL) database
Thanks.

[andy]

Hi

What JVM and options are you using?

Andy

[wgs]

I used Tomcat 6 with JVM : -server -Xmx3g -Xms3g -XX:MaxPermSize=512m
PostgreSQL 9.0 (64 bit): effective_cache_size: 5000MB; shared_buffers:1GB; max_connections:512
Alfresco 3.4c (64bit): db.pool.max:512; db.pool.statements.max:512
Server machine: CPU:core i7 3.07GHZ , 8GB RAM
OS: RHEL5

Thanks.

[andy]

Hi

Have you got lots of ACLs set on these docs 300k docs?
Roughly how mnay have ACLs set?


Andy