Loading...
 
Skip to main content

Features / Usability


File Gallery Listing VERY Slow

Whenever I click on 'File Galleries', it takes an extraordinary time to load the listing. The same is true whenever I try to add or edit a gallery. Image galleries, on the other hand, perform very well, as do the rest of the tiki features. I tried various selects directly on the tiki_file_galleries table, but none of them took even .5 sec. Any thoughts?

Thanks in advance.

Strangely enough, this happens to me too but for image galeries only😬

My guess is that you are using database for file gallery storage. If you are you will get huge speed gains and reliability by switching to file system storage.


I understand why storing the files in the database would impact performance on dl's, or even on the list of files within a gallery. The problem I'm having, however, is with the listing of which galleries are available. Like I said, selecting the list while logged directly into mysql gives me a query time of less than .5 sec. Even accounting for the time it takes php to connect to the db, it doesn't seem as though it should take that long...

Thanks again.


I implemented a file gallery using the database storage method not planning for the contents to have much volume. oops.. I was wrong. I'm not taking the performance hit mentioned. I'm planning to switch to using a directory instead but have a couple questions.
I presume I have to download all my files then upload them again once I've made the configuration change? (nuts!)
It seems that all of the files will be located in a single directory but I take it only those "assigned" to a specific gallery will be available in that gallery?

Thanks
john


I have the same issue. I've tracked it down to recursive code that browses the entire file gallery structure every time that you enter a new gallery. If you have deeply nested galleries they will move extraordinarily slow. Hopefully this is resolved soon.