RE: [PHP-DB] Question on the use of where statements
| From: | Bastien Koert | Date: | Wed, 01 Dec 2004 19:46:38 +0000 |
| Subject: | RE: [PHP-DB] Question on the use of where statements | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37518@lists.php.net to get a copy of this message | ||
actually that would reduce it since a fewwer number of rows would potentially match the query...ensure that there is a composite index on a good selection of the columns to mkae the query quicker
bastien
From: Stuart Felenstein <stuart4m@yahoo.com> To: php-db@lists.php.net Subject: RE: [PHP-DB] Question on the use of where statements Date: Wed, 1 Dec 2004 07:55:35 -0800 (PST) --- Bastien Koert <bastien_k@hotmail.com> wrote: so...best to build the statement dynamically and execute it once only if the input box has a value in it... And that is the way I'm building it. Just thinking about the scenario that somone actually chooses 75% of the options - would that potentially make a huge hit on the system. Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php