Hi all, 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???
Jon Wahl MCSE, Ethernet CNX http://www.wahlconsulting.com --------------------------------------------------------------------- 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