Rolf,

I'll see your 4.455 secs and raise you:

Dang, you win John!

Generated in 4.437 seconds in which 0.759 seconds were spent on a total of 14 queries. Zlib compression disabled.

Pretty responsive just now in fact..

Generated in 1.32 seconds in which 0.754 seconds were spent on a total of 13 queries. Zlib compression disabled.


That is pretty much normal for me. I don't know what Knology is doing with their servers, but it's working for me.

-Rob V.
Nacra 5.2
Panama City

Generated in 0.748 seconds in which 0.605 seconds were spent on a total of 14 queries. Zlib compression disabled

So It's speeding up then

Generated in 2.144 seconds in which 0.663 seconds were spent on a total of 14 queries. Zlib compression disabled.

So it's UBB/server (i.e. not the database engine) taking the time as I assume the 0.663 seoconds on 14 queries is getting returned from MySQL.

Wow, check this one out!

Generated in -0.006 seconds in which 0.000 seconds were spent on a total of 13 queries. Zlib compression disabled.

I feel younger.

-Rob V.
Nacra 5.2
Panama City

5:46 am 2 registered 5 online. Found the rates at bottom of forum:
Generated in 20.439 seconds in which 19.467 seconds were spent on a total of 14 queries. Zlib compression disabled.

Then for message: much faster?
Generated in 0.523 seconds in which 0.069 seconds were spent on a total of 6 queries. Zlib compression disabled.
Whatever this means. Hope it helps.

Generated in 8.502 seconds in which 6.774 seconds were spent on a total of 14 queries. Zlib compression

T think we can all agree things are slooooooooooooow.

Yep, agreed:



PS. 2 registered and 18 guests online

I don't know what you guys are talking about but I do know this forum seems to lock up from time to time, won't open or opens very slowly. Other times it works great...
Is that due to heavy volume on the server?

14 registered and 15 anonymous users are browsing this forum. Generated in 0.082 seconds in which 0.016 seconds were spent on a total of 6 queries. 8:34AM

Timbo, Don't feel bad...I dont know either.

A bit slow, 17 Registered and 20 Anonymous users!

Timbo: The numbers indicate that the server probably is overloaded at times. Some time it's the database backend that is slow, at other times it's the forum frontend that is slow.


E.g, my latest stats.

Generated in 12.99 seconds in which 0.013 seconds were spent on a total of 6 queries. Zlib compression disabled.


The database did its work fast, but the forum frontend which runs on the webserver (I suppose this forum runs on Apache and MySQL) used ~13 seconds to generate the page. Since it varies which subsystem is slow, I guess the server is bogged down doing something else. The question is what it is doing, as I dont see a influx of new users or increased activity.

Well where do you find these speed numbers and what's a Zlib? etc...?

You find them at the bottom of each page.

Zlib is just a software library for compression of e.g. data-streams from the web server to your browser. It's not in use on this server.

Generated in 31.768 seconds in which 30.974 seconds were spent on a total of 58 queries. Zlib compression

It is a server load issue. I will discuss with Rick the options to speed things up. It is not any 1 particular subsystem, the site is just outgrowing the server.

While we had the server down today, we added more ram to it. It now
has 1.25G of ram while before it only had 512Mb. This may help
mysql run more efficiently which may help the forum run better.
So far, it seems to be running with good speed again.
Enjoy,
Rick

Thanks! The increased speed is DEEPLY appreciated!

Rick;

I don't think the problems were MySQL; I think it was UBB/PHP was the problem.



So the query was taking 0.683 seconds but the processing of the results took the other 5.3 seconds.

So the extra ram will (maybe) helping in 2 ways

1, The resultset can be kept in Ram.
2, PHP results / arrays can also be lkept in ram.

Overall good (so far)