|
|
Posted by Brian on 06/15/05 02:29
Hi all
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?
Brian
Navigation:
[Reply to this message]
|