performance problems when too many files in one directory

[lagreen]

Hello,

I have a real performance problem when user/s tries to open directory (either through CIFS or through WEB interface) with more than 1000 files in it (it takes like 20 seconds). I have MySQL DB and Alfresco 3.2.
I did some monitoring tests and tomcat and JVM seems to be running OK. So i think that the weak point is MySQL DB. Maybe i have to rebuild the tables indexes. I serached the forum but did not find anything.

Does somebody have some ideas what to optimize or what to do?

thanx.

[jett]

derek, is there a release notes or bug tracker link I can view somewhere that mentions this?  thanks

[sam63]

You can use long path tool, it works good for such issues.