SQLite, Image Gallery and Indexing

[ccto]

Dear all member and Parallels Support,

One of our user whose site contains a Image Gallery, where the Gallery contains 2500+ images.
When someone (especially the search engine bot) comes across the Gallery, we found the PHP process runs for a few seconds (around 3 - 6 seconds).

As the user contains 2500+ images, we frequently find the user PHP process running inside the Linux top process.

Can we create some index inside the user SQLite database (i.e. data/storage/sb_modules.php) to improve the performance?

Site Builder: 4.5.0 Hotfix-20100907 (2010090712)

Please help/advise.

Thank you very much for your kind attention

 

[Dmitry Frantsev]

Hello,

As a possible solution here you could try to separate gallery into 2 or 3 ones. There is a chance that it could help.