Anyone know how i can remedy this situation??
i think i have turned off db caching, but it still seems to happen.
is there anything else i can try?
i have also tried deleting old products to free up the database.
Anyone know how i can remedy this situation??
i think i have turned off db caching, but it still seems to happen.
is there anything else i can try?
i have also tried deleting old products to free up the database.
"Parse Time: 2.253 - Number of Queries: 796 - Query Time: 1.16827769791"
796 queries for one pageview,
this is where i'm falling down.
how can i decrease this figure???
www.alphacaraudio.co.uk
i have managed to lower this figure, by turning stuff off from the main pages, but i'm still hitting this limit all the time!
this is not good for business @ all...
please please help me!
Thanks
Paul
Please refer to a related post.
Auto-switching DB login to end 1226 Error
And a workaround.
Rotating Db Users
.
A New Starter again
Thats a seriously slow parse time.Originally Posted by plowe1
To reduce the amount of queries, shut off all the boxes and functions you dont need.
Then search for all posts by user "devosc" one of his old ones will reduce that count by a few hundred potentially.
I sounds like your host has limited the number of database queries.
I would suggest a new host as they shouldnt do this.
My humble contributions....
Info at a Glance Admin, Alternative Header & Improved Whos Online + Currently working on the next!
If you have to think..... your obviously looking at the admin :)
thanks ppl,
i have looked @ the other posts, and am going down the rolling db user path.
the host has capped db queries to 50'000, which i'm hitting almost every 1/2 hour.
i don't want to change hosts, as i have got a great package (except db issue) where i can host upto 25 websites & unlimited db's 600GB bandwith, 25GB webspace, for £70 p/year
I dont think its that great if they have that low limit.
Theres a million and one places you can host your site for $1.99 a month but you run into problems like limiting the number of queries, slow sites as there are 20000 other sites on the same server etc etc.
Its better to pay say 10 quid a month and have things working than 75 quid a year for nothing.
Time to move I think....
My humble contributions....
Info at a Glance Admin, Alternative Header & Improved Whos Online + Currently working on the next!
If you have to think..... your obviously looking at the admin :)
Bookmarks