Very slow loading
Re: Very slow loading
BTW
LIMIT 86600, 100
so that's page number 866 so it's not a real user 99,9999%
you can limit amount of links in pagination or amount of galleries in a single group
LIMIT 86600, 100
so that's page number 866 so it's not a real user 99,9999%
you can limit amount of links in pagination or amount of galleries in a single group
Don't forget to run script update
Re: Very slow loading
Also looks like you have more then 10 000 000 of galleries ...
Don't forget to run script update
Re: Very slow loading
The galleries are about 4 000 000
Re: Very slow loading
Hm .. send me ssh plz to that mysql or PMA - i'll check DB indexes , may be there's something we can do about it
Don't forget to run script update
Re: Very slow loading
Ok, should be a bit faster now
Also i'd recommend to use
max_pages=100
in your navigation\pagination tag , users wont go to a page 678 and so on, so 100 pages should be enough. That will save some as well.
Also i'd recommend to use
max_pages=100
in your navigation\pagination tag , users wont go to a page 678 and so on, so 100 pages should be enough. That will save some as well.
Don't forget to run script update