Mysql query 600+ Is itnormal?

[Ansolon]

Hi,
I am using phoca gallery at 2.5 with 25 000++ photos
I have been facing high mysql load at my server. I dont know phoca cause it or not.

I have alot of categories 460 at this time and it will be more.

While I am searching the problem I saw that there are 645 queries on main page of the phoca gallery.
However there are just 2 categories shown on main page and most of the them are category query

460 × SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM ****_phocagallery AS a
LEFT JOIN ***_phocagallery_categories AS c
ON a.catid = c.id

174 × SELECT a.id, a.extid
FROM ****_phocagallery_categories AS a

645 queries and 643's are from phoca gallery is it normal? Because most of the component comes with 10 - 30 queries.


Thanks

[Jan]

Hi, no this is not normal, maybe you are using some access rights, etc. where every category needs to be cheked.

But, try to use set this:

Categories Image Ordering - set to special (which then will not load images to display them as categories images - this can save a lot of queries)
Category Image Ordering - set to special

Check the modules too, try to disable Phoca Modules in case some is enabled, etc.

Jan