wp_options to many records

RageLT – thank you for that SQL command, it just shaved ~130MB off my db. MUCH appreciated!!

I stopped using NextGen galery becaused it slowed my site bigtime, so I deleted the plugin and the galleries folders, but tons of crap remained at the MySQL database.
I came up with these queries to get rid of it:

DELETE FROM wp_pf_posts WHERE post_type like 'ngg_%' or post_title like '%ngg%' OR post_title like 'NextGen_%';

DELETE FROM wp_pf_options WHERE option_name like '%ngg%' OR option_value like '%ngg%';

DELETE FROM wp_pf_postmeta WHERE meta_key like '%ngg%' OR meta_value like '%ngg%' OR meta_value like '%NextGen%;

I successfully got rid of around 1500 useless rows and my DB file is considerably smaller.

@commando30 – Thanks for sharing those queries. If you were still using NextGEN Gallery you would see most of the “unnecessary” entries also cleared on a regular basis or forced to be cleared when using the clear image cache under Gallery > Other Options > Miscellaneous.

– Cais.

I see, thanks for the tip. However, it accounted for almost 70% of the page load time.
I used to like it, but I could not afford that impact on page load.
I decided now use the default WP gallery and another plugin to randomly generate thumbnails in a sidebar widget and my site is much quicker.
If it only had allowed other page objects to load first so users don’t feel frustrated and click away… I don’t know if it has to do with how and where the javascripts are implemented (i’m no programmer).

@commando30 – Thanks for that feedback … “performance” specific issues are being looked at for a near future release. Aside from our work to improve with every release, the upcoming “performance” release is specifically going to be focused on the over-all performance of the plugin rather than our usual smaller tweaks and tunings.

– Cais.

@photocrati

FYI

Hitting ‘Clear image cache’ under ‘Miscellaneous’ isn’t enough in my case.

Then I need to fix wp_options overhead via phpMyAdmin either optimize DB with the superb WP-DBManager plugin in one click.

These two steps turns a 800-pound gorilla into a skinny elephant ??

The DB size was reduced 30 times.

Thanks.

M.

@iframe – Perhaps you would like to submit a Bug Report (https://www.nextgen-gallery.com/report-bug/) with your site’s specifics so we can have a look around and see what may be happening.

We will need log in and FTP credentials for your WordPress installation, we may also need to have a look at your database as well. Please include the necessary credentials with your Bug Report.

Thanks!

– Cais.

unsubscribed