I've been trying to speed up my coppermine install. I've followed
my own suggestionsI've removed all database queries involving count, and hard coded the $count variable where possible.
I've removed banning and deleting of banned users
The following queries appear to be particularly resource intensive and appear to be duplicating effort - can they be removed - can anyone give me a hint as to if they are "normal" and what they are doing.
I've turned the filmstrip off in the config, but aren't the below queries relating to the filmstrip?
Any further ideas for optimisation would be appriciated.
[12] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, title, caption,hits,owner_id,owner_name from cpg134_pictures WHERE aid='2' ORDER BY filename ASC LIMIT 18790 ,10
[13] => SELECT title,keyword from cpg134_albums WHERE aid='2'
[14] => SELECT * from cpg134_pictures WHERE aid='2' ORDER BY filename ASC LIMIT 18793 ,1
[15] => SELECT title,keyword from cpg134_albums WHERE aid='2'
[16] => SELECT * from cpg134_pictures WHERE aid='2' ORDER BY filename ASC LIMIT 18794 ,1
[17] => SELECT title,keyword from cpg134_albums WHERE aid='2'
[18] => SELECT * from cpg134_pictures WHERE aid='2' ORDER BY filename ASC LIMIT 18795 ,1
[19] => SELECT title,keyword from cpg134_albums WHERE aid='2'
[20] => SELECT * from cpg134_pictures WHERE aid='2' ORDER BY filename ASC LIMIT 18796 ,1
[21] => SELECT title,keyword from cpg134_albums WHERE aid='2'
[22] => SELECT * from cpg134_pictures WHERE aid='2' ORDER BY filename ASC LIMIT 18797 ,1