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@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@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 Jefferson