1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

SQLite, Image Gallery and Indexing

Discussion in 'SiteBuilder' started by ccto, Feb 28, 2011.

  1. ccto

    ccto Basic Pleskian

    26
    90%
    Joined:
    Mar 21, 2005
    Messages:
    86
    Likes Received:
    3
    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
     
  2. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    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.
     
Loading...