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