[drupal-devel] Drupal queries
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
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:
> 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