Nested File Galleries are slow. Help!
Hi all. I'm running a Tiki 2.0 Installation that overall runs very well. We are using this for a corporate CMS. Wiki pages load very quickly, (between .1 and .6 seconds) In fact, all areas are quick besides the file galleries. I have installed a php accelerator (eaccelerator)to cut down on that overhead. The file galleries use a directory to store files. After playing with the databases a bit I think that I have concluded that the speed problems lie in the tiki_file_galleries table but I am really not too sure. I am assuming that the very deep nesting of my file galleries might be slowing me down. I have roughly 4000 files and 2000 File Galleries. Browsing from one folder to another in the file galleries is taking roughtly 8-10 seconds, much slower then the .1 seconds to load wiki pages.
Any ideas?