Re: subqueries vs. separate queries

CSN wrote:

>Is there much difference between using subqueries and
>separating out them into separate queries?
>
>
That would depend on what results your expecting, and how you intend on using the results.

For example if you want all the data in a single statement, you can't break it up, but the request will likely use more resources to complete.
If your application can cut and paste the data from multiple transactions, then simple queries may need less resources to complete, but remember that your application will require resources to cut and paste the results as well.

I have written a number of PHP functions that uses an array the results of a query to generate formatted html tables, graphs and statistical information. It is easiest to use a single complex query with subqueries, but it is possible to 'fake' a complex query by 'stacking' multiple results into an array.

Hope that helps.