SmartCJ Support Forum

How many galleries do you have ?

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

Also looks like you have more then 10 000 000 of galleries ...

The galleries are about 4 000 000

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

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.