Forum OpenACS Q&A: speed - how many tables to query at once?

Collapse
1: speed - how many tables to query at once?
Posted by David Kuczek on 03/19/01 03:08 PM
Supposing that I want to select data out of 6 different tables for one
dynamic page. Would the select be performed quicker if I do it within
one single query or should I query certain things on their own?
Collapse
2: Response to speed - how many tables to query at once? (response to 1)
Posted by MaineBob OConnor on 03/19/01 03:36 PM
I've done multiple separate selects on one table and also
I've done one huge select on the one table and the huge
select seems quite faster....  This is anecdotal.  I didn't do
a controlled timed comparison... and the selects were different.

-Bob

Collapse
3: Response to speed - how many tables to query at once? (response to 1)
Posted by Don Baccus on 03/19/01 04:20 PM
Most of the time querying at once should be faster, as Bob's testing
suggests.