how to test SQL speeds

[pensive612]

A lot of times people report tests of:

parse time
SQL time
and SQL queries


I am trying to do my own testing with some new web hosts versus old...

just wondering how people are finding these statistics.

I'm thinking phpMyAdmin, but really don't know..

can anyone pass on to the rest of us how to find this info for our own sites?
so we can do some comparisons/diagnoses of our own.


thanks in advance.

adam.

[DrByte]

Admin->Configuration->Logging->Display Page Parse Times

... and then look in the footer of your site on each page...

[pensive612]

easy enough!

thanks, Dr. Byte.



adam.

[hareslade]

Can someone advise,
If i'm displaying parse time and sql time,
is the sql time also added into the parse time?

i.s if parse time = 35 and sql time = 33,

does this mean actually, that the parse time 'doing php parsing' was 2?

I'm having trouble with my host's page serve up times, i assume results like the above mean that the sql server is overloaded

[DrByte]

The SQL time is the time it took for all SQL queries to run ... from the time of sending a query, until the results came back.... then timer stops.... and when next query is sent, timer starts again from where it left off, etc. After the final query, the number is shown.

The page parse time is the time it took from when the first line of code in index.php started processing until the footer of your page was drawn. This includes the delays introduced by any SQL queries waiting on the database.