Also using Xampp here on the timecatchers url
But production sites are running on "real servers"
If you can dump the database from your "real server" into a "look-alike server" running vanilla cpg135 with no pictures; i think you will be abel to reproduce the problem even on your sofar unproblematic "look-alike server"
I'v done som tests:
debug turned on. running on copy, fresh cpg135 (with imported data from production-server),
fresh xampplite 1.5.0 (for windows) with default my.cnf
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
[...]
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
[...]
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
139 users, less than half active, only admin has pictures. starting usermgr.php with debug enabled:
51000 pic in 30.sec
51000 pic in (optimized all tables) 29.sec
reduce from 51000 pic to 8967
8967 pict in 14.sec
8967 pict in (optimized all tables) 4.8 sec
reduce from 8967 pic to 5252
5252 pict in 3.7 sec
5252 pict (optimized all tables) in 2.9 sec.
New test:
key_buffer = 64M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
net_buffer_length = 32K
thread_stack = 1M
[...]
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
(I even tried to double to 16M on all values on [isamchk] [myisamchk], make no difference.)
139 users, less than half active, only admin has pictures. starting usermgr.php with debug enabled:
51000 pic in 27.sec
51000 pic in (optimized all tables) 27.sec
reduce from 51000 pic to 8967
8967 pict in 13.sec
8967 pict in (optimized all tables) 4.1 sec
reduce from 8967 pic to 5252
5252 pict in 3.3 sec
5252 pict (optimized all tables) in 0.98 sec.
So it helps with more memory to mysql. (prodution-server run with "key_buffer = 64M".) It helps to optimize all tables.
But many pictures make the script very heavy. It is not only a matter of number of users.
Many pictures in one album also makes modifyalb.php heavy when it produce a heavy listbox to choose which image is to represent the album. Would have been better with that function split out
Maybe the problem is the same here. As long as picturemanagement is linked closely to usermanagement; usermanagement gets heavy with a high number of pictures.
I dont know if the problem is
users + pictures, users x pictures, or only pictures, or only users (doubt that).
Mvh Andrez1