Zen Cart Understanding Parse Times/Query Counts – Part One

If you own or run a Zen Cart store, it’s a good idea to familiarize yourself with some of it’s workings. This Zen Cart tutorial will explain what Parse times, or Query counts are. This knowledge is particularly useful in the event that your page load time gets bogged down, as the parse times/query counts can provide you with important information that can help you speed your site up.

Firstly, it should be said that you have to enable the display of parse times before you can view them. After they are enabled, however, statistical information will be shown at the foot of your pages, and will be formatted like this: Parse Time: 0.314 – Number of Queries: 446 – Query Time: 0.123679

Here’s what these numbers mean:

Page Parse Time: This is the time elapsed since the first line of code in index.php started processing until you started viewing the footer of your page. This time includes the delays caused by any SQL queries waiting on your database. It is the sum of the Query Time as well as the time it takes to request data from the database, and then process the information received in response to said request. In short, CPU time makes the difference between Parse Time and Query Time.

Number Of Queries: This figure is a generated by a counter, and represents the number of hits on the database to retrieve the data used to create the page you’re viewing at the moment.

SQL/Query Time: This is the time that passes while waiting for the database provide the requested information. Which is to say, the time it took all the SQL queries to run. This figure is everything in the period from the time a query is sent, until the results come back. Many queries may run before this time has elapsed. After the final query, the number is shown.

If you need help with your zen cart web site please contact us for a quote.

zen cart plus picaflor azul equals success