acusti

I have the same issue. On most requests, the plugin does two similar looking requests that take anywhere from 10 to 35 seconds each, which is bananas. Here are actual queries from a page I just visited with the execution time above (via the blackbox debug bar):

35,091.8539 [ms]
SELECT pid , \<code>wp_options\</code>.\<code>option_value\</code> AS 'custom_post_id', GROUP_CONCAT(CONCAT_WS('@@', meta_key, meta_value)) AS 'extras' FROM \<code>wp_ngg_pictures\</code>
LEFT OUTER JOIN \<code>wp_options\</code> ON \<code>wp_options\</code>.option_name = CONCAT('wp_ngg_pictures_', wp_ngg_pictures.pid) LEFT OUTER JOIN \<code>wp_postmeta\</code> ON
\<code>wp_postmeta\</code>.\<code>post_id\</code> = \<code>wp_options\</code>.\<code>option_value\</code>  WHERE (\<code>exclude\</code> = 0) AND (\<code>galleryid\</code> IN (2)) GROUP BY wp_ngg_pictures.pid ORDER BY rand();

13,842.9251 [ms]
SELECT wp_ngg_pictures.* , \<code>wp_options\</code>.\<code>option_value\</code> AS 'custom_post_id', GROUP_CONCAT(CONCAT_WS('@@', meta_key, meta_value)) AS 'extras' FROM
\<code>wp_ngg_pictures\</code> LEFT OUTER JOIN \<code>wp_options\</code> ON \<code>wp_options\</code>.option_name = CONCAT('wp_ngg_pictures_', wp_ngg_pictures.pid) LEFT OUTER JOIN
\<code>wp_postmeta\</code> ON \<code>wp_postmeta\</code>.\<code>post_id\</code> = \<code>wp_options\</code>.\<code>option_value\</code>  WHERE (\<code>exclude\</code> = 0) AND (\<code>galleryid\</code> IN (2)) GROUP BY wp_ngg_pictures.pid
ORDER BY rand() LIMIT 3;

Those particular queries seem to be produced from the get_generated_query method of the Mixin_NextGen_Table_Extras class in /nextgen-gallery/products/photocrati_nextgen/modules/nextgen_data/mixin.nextgen_table_extras.php, and I believe they are called from the NextGEN Widget.

Here’s hoping a solution is soon found.

That shouldn’t happen! Could you tell me your OS, OS version, web browser, and web browser version, so that I can look into it?