Hi,
Turns out that my host does not like me much considering the amount of resources I have been using lately.
After few discussion and tweakings like cache, disabling random image / cat / hit counter etc, the gallery is running "ok".
The host says
At this point I am not seeing any running queries which are using excessive resources. Looking through old logs, all I can say is that the db_4images database has historically had the most performance issues. This appears to be related to keeping session data in the SQL database instead of as files.
I would like to disable session storage all together as I do not allow users to register on my site, it is just a gallery site managed by me only. The visitor has no role other than browsing the site. The site is currently running on cache.
Can this be done?
I would also like to disable any other insert/update queries if possible to reduce the load further.
Regards,
Naveen