Textpattern CMS

#1 2007-07-25 13:10:54

mattgilbert

Member

Registered: 2006-03-23

Posts: 70

Runtime vs Querytime

I could use a little help diagnosing performance issues. Can anyone tell me what sort of problems cause high Runtimes but reasonable Query times? I saw the FAQ here: http://textpattern.com/faq/136/diagnosing-performance-problems

but it doesn’t mention Query time, or the difference between Runtime and Query time.

One some pages on a site I’m working on I get figures like this:

<!-- Runtime:    22.086 -->
<!-- Query time: 0.523254 -->
<!-- Queries: 34 -->
<!-- Memory: no info available -->

This doesn’t happen on every page. For example, the main page has these stats:

<!-- Runtime:    0.1304 -->
<!-- Query time: 0.096047 -->
<!-- Queries: 22 -->
<!-- Memory: no info available -->

Thanks

#2 2007-07-25 13:22:16

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Runtime vs Querytime

Runtime = time to execute the PHP script + time to execute the SQL queries (query time).
Try disabling DNS lookups as suggested in that FAQ item.

Last edited by ruud (2007-07-25 13:24:27)