FF playing up?

[ChrisUK]

Hangs for over an minute then lies.

Page generated in 22.835 seconds (0.65% PHP - 99.35% MySQL) with 14 queries

Did you try other sites during that time?

 

[Eklipze3k]

Hangs for over an minute then lies.

Page generated in 22.835 seconds (0.65% PHP - 99.35% MySQL) with 14 queries

When you have to wait ages for the page, then it comes back with a low number of seconds - this is a PHP hang and what I'm still trying to resolve.

Maybe try reading Ben's posts

 

[Shadeyman]

Did you try other sites during that time?

Yes, got bored of waiting so I checked my email, left a message for a friend on Facebook and read my messages on another forum. All without a problem.

Maybe try reading Ben's posts

I did, doesn't stop it being annoying though does it?

 

[Shadeyman]

Took about a minute to load.

Page generated in 5.884 seconds (-54.68% PHP - 154.68% MySQL) with 20 queries

 

[ben]

Right, I've finally got the slowqueries logfile working - and the garage is cropping up a lot.
Disabled it for now - so let's see if that makes any difference.

TBH I don't think that's going to be so simple - but always best to start with the simple things just in case!

 

[JustAndy]

The garage is currently closed. Please check back later.

sounds like every other garage when you need something

 

[ben]

I don't like to tempt fate, but since that was disabled - the site hasn't timed out once ... usually it will trip the monitors once or twice an hour ...... :chin:

 

[ChrisUK]

Buggy piece of junk . Just leave it off .

 

[Stu DemonD]

I still don't seem to have issues like others are showing - 1 minute hangs, really :chin: - so I think it is more localised or ISP based

 

[ben]

Oh it was definitely a problem, before that switch we were running at a 98.8% uptime with an average 2.5sec response (on the pages I was monitoring).

Since the Garage was switched off (can it really be so simple??) the uptime has been 100% with an average 2.1sec response time...

 

[blu73]

well i've no issues for a while but will let you know if i get a hang from now

 

[dave]

seems to be faster here and i havent changed my isp or moved house

 

[Shadeyman]

:yeahthat: *crosses fingers*

 

[Shadeyman]

Just been sorting out the missus's ebooks and stubbled accross a PDF document of interest, "PHP and MYSQL Bible".

This seems like an appropriate thread to attach it to. :devil:

 

[ChrisUK]

Might be helpful if it wasn't third party code causing the problem :nerner:

Good book by the way I've snatched that one for my stash . Just finished the Cisco CCNA Telephony one, boy my head's full of crap

 

[Shadeyman]

Glad its of use to someone, I had a quick read, but it ment nothing to me so just filed it with the others. Stumbled accross it again earlier while loading a few more books onto the missus's Kindle.

By the way this is the worst hang I've had all day.

Page generated in 13.490 seconds (-88.23% PHP - 188.23% MySQL) with 19 queries

Much better.

 

[jip0]

i cant actually remember the last time i had a problem

 

[ben]

And we have a winner ....

# Query_time: 63.625000 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 31940539
SET timestamp=1326394302;
SELECT gi.attach_id, gi.attach_thumb_location, guv.* FROM vb_garage_user_vehicle guv LEFT JOIN vb_garage_images gi ON guv.vehicle_id = gi.vehicle_id WHERE guv.active = '1' ORDER BY guv.vehicle_id DESC LIMIT 1;
# Time: 120112 18:51:46

What the **** .... how badly optimised is that query?!?!

And that ladies and gentlemen, is what's been screwing us over for the last god knows how long ....!

 

[blu73]

it is just nonsensical to me lol.. glad you found it though. have a pat on the back Mr Ben.

 

[jip0]

go ben!