some very slow queries

southdreamz

Dear Support,

I'm running with ZenPhoto 1.2.7, almost 2 years without any issues. But, today i got message from my hosting server, says that "some very slow queries taking over 2,700 seconds to run". can you look at that queries here: http://justin.dreamhosters.com/palpal1.html and help me to resolve this issue.

Thanks & Regards,
palPalani

acrylian

You have quite a lot images per album, do you? It would really help if we would get the real error message with a line number (if there is one) and/or some info when this exactly appears. That will just save us some time to search for that query.

southdreamz

I am sorry i do know what happen today.I got message from my support that they have removed my data base.He did not provide any details and this what the link (http://justin.dreamhosters.com/palpal1.html)this is our website Gallery.southdeamz.com that it is taking 2,700seconds to run they did not give any specific details.

sbillard

This is a fairly normal (if perhaps large) query for a search. It was pretty draconian for your support to remove the database, nothing wrong with it. I suggest you find a new provider with more server power to handle your needs. (And a better customer concern so they do not arbitrarily remove your database.)

southdreamz

Thanks @sbillard, For time being i hided the search feature.