• Resolved philchillsofade

    (@philchillsofade)


    Hi,
    I have a question concerning the speed of WPPA. I have a bunch of WPPA photo albums on my site and it takes several minutes to load them even for the albums with only ~25 photos (www.phil.chillsofa.de/wordpress/?page_id=1448). I am wondering why this is? When I initally tested your plugin I did not experience this behavior. Is this because the WPPA library is now several 1000 pictures large? Is there any way to signifcantly speed up the loading times? I like the plugin a lot, but in this configuration now it is nearly unusable.

    Thanks for your help in advance,
    Phil

    http://wordpress.org/extend/plugins/wp-photo-album-plus/

Viewing 15 replies - 1 through 15 (of 20 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    You have all albums in the above link listed separately like:

    %%wppa%% %%cover=13%%
    %%wppa%% %%cover=18%%
    %%wppa%% %%cover=…
    etc.

    If you make a dummy album, say its named California with id=4711 and set the parents of all the albums to California and use the script:

    %%wppa%% %%album=4711%%

    You have the same result, but (a little) faster. This will not fix it all, but helps and is easier to maintain. You can also set the sequence order of the albums in the album admin.

    Please check Table IX-A3: allow wppa+ debugging, then i can see a little more.

    Thread Starter philchillsofade

    (@philchillsofade)

    Thanks for your answer. I will try your suggestion with the parent albums during the next days. I am not sure if this will solve the problem. It is equally slow if I point only at one album entry in my blog posts: http://phil.chillsofa.de/wordpress/?p=1830. I also turned debugging on and reinitialized the plugin. Unfortunately I don’t have control over cleaning up the cache of the server.

    Thanks,
    Phil

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    To my info you are at wppa+ rev 4.6.12, hotfix 001.

    Do you mind updating to the current version 4.7.12.?

    It has more diagnostics in debug mode, so i can see more… especially time needed for queries.

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Update to 4.7.13, it usess much less database queries, this wil help.

    I will come with more advise later.

    Thread Starter philchillsofade

    (@philchillsofade)

    This made a very big difference. Thank you. Do you think that the time for the quries is now normal on my site?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    It looks rather normal (acceptable) now. However, i will still go further searching for performance improvements. In the mean time it may be usefull if you find out if you can ‘manually’ optimize database tables. Look for:

    wp_wppa_albums, wp_wppa_photos, wp_wppa_rating, wp_wppa_comments, wp_wppa_iptc, wp_wppa_exif.

    I will build this in a later.

    To be continued

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Another 15% better in 4.7.14

    Closed for now.

    Hi I have the same problem. I have the latest version but unfortunatelly my galleries are slow. I already have a parent album for my sub-albums. potohori.gr. Thanks in advance

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Plese: supply a link to a page that displays an album or a slideshow, Greek is no my favorite language, so menues or links dont tell me anythig.

    Also, please check Table IX-A3 (allow WPPA+ Debugging). This enables me to see a lot of diagnostic data, without affecting normal users’s views.

    Sorry, the link is http://potohori.gr/multimedia/photos/
    I already checked Table IX-A3 (allow WPPA+ Debugging). Thanks for the quick response

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Now i need a login….

    Ok where can I send you a username and password? Sorry for all these questions but I am very new to this

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Email to opajaap at opajaap dot nl

    Ok, I send you a username and password. Thank you!

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Did not receive yet

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘[Plugin: WP Photo Album Plus] WPPA very slow’ is closed to new replies.