Re: Multiple Querie or Long- Speed

2001-04-14 Thread Tonu Samuel

On 13 Apr 2001 18:02:19 -0400, bryan wheelock wrote:
 Is a more complex single query going to run faster on a server than
 several smaller queries where the results are set to variables and then
 used as criteria in tertiary queries.


Usually yes as you do not have network and parsing overheads.

   Tnu


-
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




Multiple Querie or Long- Speed

2001-04-13 Thread bryan wheelock

Is a more complex single query going to run faster on a server than
several smaller queries where the results are set to variables and then
used as criteria in tertiary queries.


Bryan


-
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