topic Re: Search performance in Alfresco Archive

Search performance

wgs — Tue, 01 Mar 2011 10:49:45 GMT

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),

Re: Search performance

andy — Mon, 07 Mar 2011 12:28:07 GMT

Hi

What JVM and options are you using?

Andy

Re: Search performance

wgs — Fri, 15 Apr 2011 10:24:24 GMT

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.

Re: Search performance

andy — Mon, 18 Apr 2011 13:53:24 GMT

Hi

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

Andy