At 08:33 PM 2/16/2002 , you wrote:
>Hello
>
>I am new to the subject. I am experimenting in mysql via PHP with a nice 
>book (PHP and MySQL
>Web development). My question is how many queries to mysql, made via PHP, 
>should considered
>ok for efficiency. I know it has much to do with the size of databases, 
>but I would like to get an
>idea. Thanks.
>
>      Nikolas

Nikolas,
         One thing you may want to implement is adding a LIMIT clause to 
your queries to prevent users from returning too many rows. Mine would be 
set to 100 and in a lot of cases, fewer than that. The queries will run 
much faster.

Brent


---------------------------------------------------------------------
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

Reply via email to