LucyVanAngel

Hi,

i got a big problem,
i use the nextgen gallery plugin on one of my blogs, the blog has already 12k posts and aprox 300k images in the nextgen database. although the blog it self loads perfect (also due to a very fast server) the wp admin became incredibly slow. my host said its the nextgen gallery plugin which makes it load so slow. each time i am uploading a picture zip file to the database the plugin is running "SELECT meta_data FROM wp_ngg_pictures" which returns over 332000 rows.
Is there a way to stop this ? Or a way to reduce the requests ?

here is the php code:


// Query database for existing values
// Use cache object
$old_values = $wpdb->get_var( $wpdb->prepare( "SELECT meta_data FROM $wpdb->nggpictures WHERE pid = %d ", $id ) );
$old_values = unserialize( $old_values );