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@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: RE: Question on the use of where statements
Date: Wed, 1 Dec 2004 07:55:35 -0800 (PST)
--- Bastien Koert <bastien_k@xxxxxxxxxxx> 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
