I've been a long time user of nextgen gallery with minimal issues in the past so I was really surprised to learn from my host (hostgator) that nextgen was causing excessive cpu usage on our hosting platform. Here's a portion of the recent message I received from one of their system admins:
"It appears the account is going over the MySQL row read limit. I enabled logging for a bit and browsed the site and found this kind of query repeated frequently:
[-] allmonst_wrdp3 | 44272 | | Using where | SELECT image_slug FROM wp_ngg_pictures WHERE image_slug = 'hooked-21' AND NOT pid = 0 LIMIT 1
The 1st column is the database name, the second is the number of rows read, the last column shows the query. As you can see the query is reading over 40,000 rows to load one image from the wp_ngg_table, which appears to be the table for the plugin called NextGEN Gallery. You may want to add some indexes to that MySQL table, or consider replacing that plugin with another. If possible, I would suggest checking with the plugin developer for direct assistance."
Has anyone else encountered similar issues, and if so was there any resolution? I used the plugin to maintain 400+ photo galleries on my site, totaling over 44,000 photos. I'd hate to have to move everything away from nextgen but I don't know MySQL, so I have no idea how to fix it.