Plugin consumes 10 Mb of memory on every page

@webvitaly – Do you have plans to expand the plugin to show what specific queries are being made? I could see that being of use linked from the admin bar display details.

– Cais.

To show SQL queries you may add this code to your wp-config.php file:

define('SAVEQUERIES', true);

And add this code to active theme’s footer.php file:

<?php
if (current_user_can('administrator')){
    global $wpdb;
    echo "<pre>";
    print_r($wpdb->queries);
    echo "</pre>";
}
?>

Or you may use one of these plugins:

• Debug Queries
• Query Monitor

And try to compare list of SQL queries when NextGen Gallery plugin is activated and disabled.

@webvitaly – Thanks for the tips and links … I’ll have one of our developers review this topic.

– Cais.

Check out the “NextCellent Gallery – NextGEN Legacy” plugin.
It is a fork of NextGenGallery plugin ver 1.9 and it consumes about 1Mb of memory and makes 5 SQL queries.
And provides same functionality what NGGallery version 1.9 had and majority of users needs.

@webvitaly – That plugin is essentially a different code base in comparison to NextGEN Gallery.

– Cais.

This info will be useful for users with shared hosting with limited resources.
I have average site with few different plugins installed on the website.
I tried to compare how many resources consumes NGGallery and NextCellent Gallery plugins.

Detailed stats on my website:

/wp-admin/ (admin section)

• 26 sql; 0.35 sec; 23.43 MB; – without Gallery plugins
• 46 sql; 1.54 sec; 33.08 MB; – with NGGallery
• 27 sql; 0.38 sec; 25.35 MB; – with NextCellent Gallery

/index.php (homepage)

• 27 sql; 1.00 sec; 29.72 MB; – without Gallery plugins
• 42 sql; 1.15 sec; 38.93 MB; – with NGGallery
• 27 sql; 1.00 sec; 31.17 MB; – with NextCellent Gallery

/images/ (page with the gallery)

• 30 sql; 0.91 sec; 28.96 MB; – without Gallery plugins
• 73 sql; 2.03 sec; 40.45 MB; – with NGGallery
• 31 sql; 1.03 sec; 30.49 MB; – with NextCellent Gallery

Enough Said.

P.S. NextCellent Gallery plugin is fully compatible with NGGallery. But before using it, you should disable NGGallery because these two plugins cannot be activated at the same time.

@webvitaly – You’re still basically comparing two different code bases … and we have not considered them “fully compatible” for several versions now.

– Cais.

I was using galleries, albums and shortcodes.
After replacing NGGallery with NextCellent Gallery plugin everything is working without any issues.
And much faster ??

@webvitaly – You are more than welcome to use the older code in that plugin, I’m just noting that comparing these two is comparing two different code bases.

Thanks!

– Cais.