Slow Database

Joined
Apr 19, 2005
Messages
6,175
Reaction score
2
Ian Cunningham said:
What happens when you try to reply to them Viv? It could just be a one-off as I cleared a cache before I logged out of the server - does it work ok now?

I don't know if it's just at this end, but the site seems lightening fast at the moment :eek: I didn't think this tweak would have had such a big impact.

Its fine now Ian the ones I couldn`t reply to seem ok now Was >[UNAVAILABLE] NOT FOUND.
 

muckshifter

I'm not weird, I'm a limited edition.
Moderator
Joined
Mar 5, 2002
Messages
25,739
Reaction score
1,204
slow, slow, quick quick, slow ... has always been like that for me.


every time someone says something, it gets fast.


:D
 
Joined
Apr 19, 2008
Messages
4,081
Reaction score
1
Ian Cunningham said:
What happens when you try to reply to them Viv? It could just be a one-off as I cleared a cache before I logged out of the server - does it work ok now?

I don't know if it's just at this end, but the site seems lightening fast at the moment :eek: I didn't think this tweak would have had such a big impact.

Over the last few days when I have tried to reply to posts, sometimes after clicking "Submit Reply" I can wait upto 5 minutes before the reply is submitted. This is also when I was been timed out.
This evening has been a mixture of extremely slow and lightening fast.
Another thing I have noticed over the last week or so isw. Sya for instance when I log onto the site ifrst thing in the morning. Normally around 8am say there are 15 unread posts/threads. I always first check WCG to see how I/we are doing then I go back to the home page and click "Since last visit" and from there I have been getting the " Sorry no matches" or what ever it says....Yet I have only checked 1 post/thread...

Hope ya can understand what I mean....
 
Joined
Apr 19, 2008
Messages
4,081
Reaction score
1
V_R said:
What he said. :)


Not what he said...Still as slow as the que in the Post Ofiice on pension day....
nod.gif
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Madxgraphics said:
Not what he said...Still as slow as the que in the Post Ofiice on pension day....
nod.gif

If you ping pcreview.co.uk, what response time do you get? I've had a look at the database "slow log" and there's next to nothing in there, so it could be a routing problem rather than the server now (especially if it times out, as I can't see why that would happen). :)
 
Joined
Apr 19, 2008
Messages
4,081
Reaction score
1
Ian Cunningham said:
If you ping pcreview.co.uk, what response time do you get? I've had a look at the database "slow log" and there's next to nothing in there, so it could be a routing problem rather than the server now (especially if it times out, as I can't see why that would happen). :)


Screen shot attatched...
 

Attachments

  • pingpcreview.png
    pingpcreview.png
    7.2 KB · Views: 251

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
143ms isn't bad considering the server is in the states, hmmmm... :confused: how long does it take to load this thread for example? It seems near instant for me when I click on it now.
 
Joined
Apr 19, 2008
Messages
4,081
Reaction score
1
Ian Cunningham said:
143ms isn't bad considering the server is in the states, hmmmm... :confused: how long does it take to load this thread for example? It seems near instant for me when I click on it now.


Ping has been much much higher than that. sometimes nearer 400...

Ok if I am on say Facebook and I want to check something on here and I goto a link in the address bar it can take upto say 50 seconds to load PCR home page, and then its not fuully loaded. Place holder where some images should be...Then there's the getting onto what ever threads have been started that day...Click on them and sometime you hvae to click a few times
Its the same if I click on Home/Reviews/ Articles etc.. I get the drop down and click on it and sometimes have to click a few times..It doesn't even show in bottom left corner of browser window that whatever has been founsd or connecting to...
I thought maybe it was me but have cleared out Firefox and Internet Explorer...But still the same..
 

nivrip

Yorkshire Cruncher
Joined
Mar 21, 2007
Messages
10,905
Reaction score
2,139
Must be you, MadX. Still almost instant for me over the last 18 hours or so. :nod:
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Do you get that on any other sites too? I don't think that's a server problem, so it could be the link between your ISP and the hosting company - it's the only thing I can think of now?
 
Joined
Apr 19, 2008
Messages
4,081
Reaction score
1
Ian Cunningham said:
Do you get that on any other sites too? I don't think that's a server problem, so it could be the link between your ISP and the hosting company - it's the only thing I can think of now?


Just PCR and sometimes Halifax Bank... I thought maybe it was my PC, but get the same on my Mac...Probably is from my side as I remeber when I was at my brothers on Monday his laptop was connecting instantly...
 
Joined
Apr 19, 2008
Messages
4,081
Reaction score
1
Just thought i'd add to this.. I think a fare bit of slowness might be me..I ran Ccleaner, and did a hard reset on my router and PCR seems pretty normal now. But saying that Now I can't get on Fartbook...
 
Joined
Apr 11, 2007
Messages
956
Reaction score
59
I also have found the site rather slow of late,I thought is was my `phone connection.

historian :(
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Madxgraphics said:
Just thought i'd add to this.. I think a fare bit of slowness might be me..I ran Ccleaner, and did a hard reset on my router and PCR seems pretty normal now. But saying that Now I can't get on Fartbook...

Good stuff :D Well, apart from not being able to get on Facebook!

historian said:
I also have found the site rather slow of late,I thought is was my `phone connection.

Is it even slow today, Historian?
 

V_R

¯\_(ツ)_/¯
Moderator
Joined
Jan 31, 2005
Messages
13,572
Reaction score
1,888
Still nice and rapid for me. :)

My ISP's just upgraded me to ADSL2+ too at long last! :D
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Glad it's running well - I have to admit I've never seen it this speedy either... I hope it lasts :D The coding change doesn't seem to have exhibited any bugs which is a relief :)
 
Joined
Apr 19, 2005
Messages
6,175
Reaction score
2
Ian Cunningham said:
Glad it's running well - I have to admit I've never seen it this speedy either... I hope it lasts :D The coding change doesn't seem to have exhibited any bugs which is a relief :)

No I ain`t itching :lol:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Improved forum search 4
Server Move 15
Server Downtime 14th May 2009 13
Becky 83
Very slow and intermitent internet crashes. 5
Database Server 11
PC Review Software Upgrade 10
Slow database 1

Top