Hi Jon, > I have a query that is returning 15 records per page. For each record, I > may do up to 2 subselects - this is done by issuing seperate queries inside > the 15 record recordset (depending on the level of detail chosen by the > user). The problem is that things slow down quite a bit when doing the > subselects - even though they return 5-10 records each. Basically this is a > parent record with up to two children recordsets. I think there may be a > faster way to do this, but am not quite sure what sql tools are at my > disposal. Anyone have an idea of how to approach this???
The theoretical answer is "yes", using joins. Can you post some details about the language/tools you are using, table definition(s), the query/ies, and/or the practical task you are setting out to perform? The more information you can provide, the better the chance that we can offer a sensible discussion/answer. Regards, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
