|
Posted by Andy Hassall on 06/15/05 02:42
On Tue, 14 Jun 2005 23:29:20 GMT, "Brian" <not@given.com> wrote:
>I am running the follwoing statment
>
>SELECT DISTINCT orderno,store,storename,date,dnote FROM $table WHERE
>lcase(storename) = lcase('$town') ORDER BY dnote
>
>The trouble is it's when searching a table of 40,000 its slow, is there a
>better way?
Depends on your database and depends on your schema.
--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Navigation:
[Reply to this message]
|