Slow response time

jwstewar · Nov 28, 2004

( Generated in 26.17 seconds in which 26.118 seconds were spent on a total of 16 queries. Zlib compression enabled. )

Just got that going into the credit card thread.

DocHeb · Nov 29, 2004

Current adjusted date is: 11/29/04 08:29 AM

Generated in 79.339 seconds in which 79.288 seconds were spent on a total of 20 queries. Zlib compression enabled.

Inspector507 · Nov 29, 2004

Chris,
I had one at around that time this morning..........86 seconds.

Glenn9643 · Nov 29, 2004

11:22 am, entering the "Projects" forum.
Generated in 51.308 seconds in which 51.285 seconds were spent on a total of 15 queries. Zlib compression enabled.

Golfgar4 · Nov 29, 2004

Going in to NH Buying/Pricing forum -

Generated in 94.993 seconds in which 94.978 seconds were spent on a total of 16 queries. Zlib compression enabled.

Ibrahim · Nov 29, 2004

Yeah, that was me.

I don't want to get into the details right now. But this is part of the response to the slowness. (We figure if we triple load times, when it goes back down to normal, everyone will be thrilled... /forums/images/graemlins/wink.gif j/k)

But we'll figure out how to fix this up nicely. And then we'll be fast again. At least, that's our current plan. Please bear with us during this time.

-Ibrahim

Inspector507 · Nov 29, 2004

You'll work it out so it's even faster, it's happened before /forums/images/graemlins/grin.gif

bczoom · Nov 29, 2004

Is this related to all the SQL error messages I was getting?
Here's some of them.

SQL ERROR: Mon, Nov 29 2004 14:54:21 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154
SQL ERROR: Mon, Nov 29 2004 14:54:21 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154
SQL ERROR: Mon, Nov 29 2004 14:54:21 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154
SQL ERROR: Mon, Nov 29 2004 14:54:21 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154
SQL ERROR: Mon, Nov 29 2004 14:54:21 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154
SQL ERROR: Mon, Nov 29 2004 14:54:21 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154
SQL ERROR: Mon, Nov 29 2004 14:54:21 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154

SQL ERROR: Mon, Nov 29 2004 14:49:56 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154

Warning: mysql_connect(): Can't connect to MySQL server on 'dbserv1' (113) in /home/tractorb/htdocs/forums/mysql.inc.php on line 35
SQL ERROR: Mon, Nov 29 2004 14:57:00 -0600 Database error only visible to forum administrators

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 45

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 128
SQL ERROR: Mon, Nov 29 2004 14:57:00 -0600 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tractorb/htdocs/forums/mysql.inc.php on line 154

Golfgar4 · Nov 29, 2004

( But we'll figure out how to fix this up nicely. And then we'll be fast again. )

Never thought anything different! /forums/images/graemlins/smile.gif

Just wanted to make sure you'd seen some of the different problems. After all, you HAVE asked in the past for the members to let you know when there's a problem! /forums/images/graemlins/smirk.gif /forums/images/graemlins/grin.gif

Inspector507 · Nov 29, 2004

Sure we will Garry.......we want this free thing to be FAST too /forums/images/graemlins/grin.gif

jwstewar · Nov 30, 2004

(
Current adjusted date is: 11/30/04 12:02 PM
Favorite Forums (Toggle)

Generated in 49.785 seconds in which 49.727 seconds were spent on a total of 22 queries. Zlib compression enabled.

)

Going into the main page.

Ibrahim · Nov 30, 2004

Yep,

That was me again.

I'm doing some things that just can't wait for off-peak hours.

-Ibrahim

Inspector507 · Dec 2, 2004

We're creeping back up tonight again /forums/images/graemlins/crazy.gif
 Generated in 27.864 seconds in which 27.834 seconds were spent on a total of 16 queries. Zlib compression enabled.

Inspector507 · Dec 2, 2004

Generated in 63.862 seconds in which 63.846 seconds were spent on a total of 16 queries. Zlib compression enabled

Bird · Dec 2, 2004

Jerry, for me, it's erratic; fractions of a second many times and then it seems to hang up and take many seconds every once in awhile. And of course, I don't know whether it's TBN's server or just Comcast. /forums/images/graemlins/confused.gif

Golfgar4 · Dec 2, 2004

Well Bird, I can tell you that it's not Comcast, because it's happening to me too. And I don't have Comcast! /forums/images/graemlins/crazy.gif /forums/images/graemlins/tongue.gif

gsxr1100 · Dec 3, 2004

You mean "Concast", right? I have tried it at college and work and it is sloooow also. So I can't bash my local ISP even though I can't stand them.

Muhammad · Dec 3, 2004

We made some changes earlier today and are keeping track of any queries that take more than 2 seconds. So far things seem to be running smoother but we're still interested if you experience any load times over 5 seconds, and what you were doing when that occured.

Ibrahim · Dec 4, 2004

Well it's been about 24 hours with the new tweaks and I'm happy with the results. We'll keep monitoring, but this is what it looks like now:

Uptime: 24hours
Queries: 4.3 Million
Ave Queries a Second: 53
Total Queriest taking longer than 2 seconds: 95

That's good.

And we'll be monitoring it further.

-Ibrahim

Bird · Dec 7, 2004

( Generated in 0.092 seconds in which 0.078 seconds were spent on a total of 16 queries. Zlib compression enabled. )

When it does it in less than a tenth of a second, and I blink about that time, sometimes I'm sittin' here waiting for the next page, then suddenly realize it's already there. /forums/images/graemlins/crazy.gif /forums/images/graemlins/blush.gif