I am finding that my gallery updates are taking an extraordinarily long time to complete.
I specifically experience the slowness when I copy the default "Alt & Title Text" (name automatically created from the file name of uploaded image) to the "Description" and add a custom name to the "Alt & Title Text." A page of 50 images can take up to 20 minutes.
I know that my NGG tables are large, so I have attempted to optimize my DB, but this seems to have little affect. I have also verified that my MySQL seems to be adequately optimize using both tuning-primer and mysqlprimer.
What can I try to speed this process up? Thanks in advance for any help given.
My Nextgen Gallery details are as follows...
Nextgen Gallery ver 1.9.13
Operating System : Linux (64 Bit)
Server Memory : 2621440k
Server : Apache
Memory usage : 11.97 MByte
MYSQL Version : 5.5.30-cll
SQL Mode : Not set
PHP Version : 5.3.23
PHP Safe Mode : Off
PHP Allow URL fopen : On
PHP Memory Limit : 512
PHP Max Upload Size : 128M
PHP Max Post Size : 8M
PCRE Backtracking Limit : 500000
PHP Max Script Execute Time : 60s
PHP Exif support : Yes ( V1.4 )
PHP IPTC support : Yes
PHP XML support : Yes
GD Version : bundled (2.0.34 compatible)
FreeType Support : Yes
FreeType Linkage : with freetype
T1Lib Support : Yes
GIF Read Support : Yes
GIF Create Support : Yes
JPEG Support : Yes
PNG Support : Yes
WBMP Support : Yes
XPM Support : Yes
XBM Support : Yes
JIS-mapped Japanese Font Support : No
Tables in database
wp_ngg_gallery 1,204 rows MyISAM utf8_general_ci 186 KiB
wp_ngg_pictures 56,901 rows MyISAM utf8_general_ci 29.3 MiB