Page Generation Time

[Eon]

Ok, I am still pretty new to all this, but when it gives me the page generation time at the bottom, it then gives me percentages for the php and the sql. What exactly does that stand for?

Is it showing the percent of the total time that each is using?

Say for instance..

Page generation time: 4.7584s (PHP: 18% | SQL: 82%)

That means that 18% of the time is spent on php and 82% is spent on the sql?

Which means an extrememly slow sql server? Considering this is a new install.

[Adrian Rea]

I would think something is at faulton your install or sql server. Here the time is [Page generation time: 0.6288s (PHP: 78% | SQL: 22%) and even on old integramod was [Page generation time: 1.7783s (PHP: 67% | SQL: 33%) | SQL queries: 389 | GZIP disabled | Debug on]
note php always larger than sql

A

[Eon]

Right that is the way it is on my actual site as well.

But on my test site and server it is what I posted.

So those percentages mean what I thought?

[Adrian Rea]

is your test site on local pc or server? is the test site a copy of the live site?

A

[Michaelo]

This is very strange <img>
Page generation time: 4.7584s (PHP: 18% | SQL: 82%)... Does it not give the number of queries at the end of this line?

[Eon]

Well yeah, but I didn't think they were relevant.

[Page generation time: 3.1479s (PHP: 16% | SQL: 84%) | SQL queries: 48 | GZIP disabled | Debug on]


That is from it just loading. This is on my test site on my server. They are saying there may be a temporary problem and that will check into it. But I don't know.

The test site is the one I am using for beta..

[Michaelo]

Enable GZIP and go to the same page and look for a peed increase... could be server but...
Mike

[Eon]

[Page generation time: 3.1557s (PHP: 13% | SQL: 87%) | SQL queries: 51 | GZIP enabled | Debug on]

That didn't work Mike.

Probably my server as I am not paying a lot for it. LOL But I am still paying so it should be fast I say..

[binh.tang]

I too get this at times as well.

Haven't really found the root of the problem or a real solution.

What I've done to try to 'ease' the problem:
1. Made sure all tables have INDEXES on them.
2. Made sure the sessions table isn't filling up.
3. Enable Slow Queries logging to find out what queries are taking a long amount of time.

I'm still trying to solve the same problem as well.

My site gets these at most time:

[Page generation time: 2.0047s (PHP]72%[/color]) | SQL queries: 243 | GZIP enabled | Debug off]

But luckily I run two dedicated server (one as Web Server and one is a SQL Server) so it's not that noticable.

[Helter]

mysql5?

[binh.tang]

Hi HelterSkelter,

How do I find this out?
I have two dedicated servers, one is the webserver and the other is a SQL Server.

Can I find this out from the IM Admin ACP?
Under [Tools] --> "PHP Info" I can see the following:

Client API version - 3.23.49

Is that it?

[Helter]

go to acp/tools/php info
scroll down to

"Client API version"

Im only asking because Ive dealt with 3 other sites reporting the same issue. All were php5/mysql5 sites. One of these site, i installed here with php5/mysql4 and queries were around 80 and as soon as I installed it on his php5/mysql5 site, queries hit close to 300 within the first hour.

[binh.tang]

Hi HelterSkelter,

Did that and got this

Client API version --> 3.23.49

Does that mean I have msql 3.23.49?

[Helter]

yes, you might want to seriously think about upgrading. Try mysql 4.1.22
in config.php, change mysql to mysql4
You should have no upgrade issues.

[binh.tang]

Thanks for that.

I contacted my hosting company and they told me I have mysql 5.0.27 (?!)
Even though IM tells me Client API version --> 3.23.49

Does that sound strange?

Is there another way to tell? I'm not sure whether my hosting company is lieing to me or whether IM is wrong?

[Helter]

im guessing your host is accurate. I dont think there are any hosts running mysql3x unless specificly requested by the client. Besides, it is such an easy upgrade, they would have no reason to lie about that and php5 is the likely reason for your high queries, though I dont know why

[binh.tang]

So do you think I should DOWNGRADE to mysql 4 and as well as php4? Or just only mysql?

[Helter]

I dont know that that will help you, I just know that the sites ive seen that seem to have rediculiously high queries are all mysql5. I would stay with php5 though because it is more secure.