[drupal-devel] Drupal queries

Larry Garfield larry at garfieldtech.com
Wed Oct 5 23:57:05 UTC 2005

The Devel module is exactly what you want.  It lists every query run, the time 
it took for each query, and flags those queries that were run multiple times.  
It also provides you with a total.  

As for picking a site to test on, uh, you're on your own there. :-)  Are you 
trying to figure such things out before you try Drupal?  That won't get you 
very far.

A typical page in my experience, depending on the page, can be anywhere from 6 
to 100 queries.  Most of them are reasonably fast queries, though.  (Yes, 
I've written pages that had nearly 100 queries before I bypassed the API and 
made some optimizations. <g>)  The caching system helps a lot, too.

On Wednesday 05 October 2005 01:44 pm, piotrwww at krukowiecki.net wrote:
> Hi,
> I need some overview of what kind of queries are executed on real drupal
> site and in what amount. I need a list of queries sent to _db_query().
> IIRC devel module has such possibility, it can list all queries on a
> page, with number of executions (and maybe time?).
> The best would be moderately rich site (maybe a front page with some
> stories/flexinode type or other and with blocks - latest posts, users
> online, some images etc) - something with a variety of everything...
> At least that's the best site for benchmarking. Some average rich site.

Larry Garfield			AIM: LOLG42
larry at garfieldtech.com		ICQ: 6817012

"If nature has made any one thing less susceptible than all others of 
exclusive property, it is the action of the thinking power called an idea, 
which an individual may exclusively possess as long as he keeps it to 
himself; but the moment it is divulged, it forces itself into the possession 
of every one, and the receiver cannot dispossess himself of it."  -- Thomas 

More information about the drupal-devel mailing list