Very slow loading

admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Very slow loading

Post by admin »

How many galleries do you have ?
Don't forget to run script update
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Very slow loading

Post by admin »

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
Don't forget to run script update
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Very slow loading

Post by admin »

Also looks like you have more then 10 000 000 of galleries ...
Don't forget to run script update
filthlab
Posts: 118
Joined: Tue May 30, 2017 6:49 am

Re: Very slow loading

Post by filthlab »

The galleries are about 4 000 000
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Very slow loading

Post by admin »

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
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Very slow loading

Post by admin »

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.
Don't forget to run script update
Post Reply