You are here: Re: Faster? « PHP SQL « IT news, forums, messages
Re: Faster?

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация