[dba-SQLServer] Re: Faster Searching

Mark,

Something is wrong with the way you are searching.
I have a 750,000+ record table that I do a search in
using ODBC against SQL 2000 and it takes less that 2
seconds. I am using Like %something% in the criteria,
so I am not even doing an exact search.  The time went
from about 20 seconds to less than 2 seconds after I
indexed the column.

Robert

At 12:00 PM 2/19/2004 -0600, you wrote:
>Date: Thu, 19 Feb 2004 12:52:18 -0500
>From: "Mark Boyd" <MarkBoyd at McBeeAssociates.com>
>Subject: [dba-SQLServer] Faster Searching
>To: "SQLServerList" <dba-SQLServer at databaseadvisors.com>
>Message-ID:
>         <B408574ACAFCAE49BEE6B626C3CD9F2D3B32BA at wpamail2k.mcbassoc.com>
>Content-Type: text/plain;       charset="us-ascii"
>
>I have a SQL2000 table with about 5000 records.
>
>This table is linked to an Access DB.  When I try to search records thru
>the form, it is taking about 5 minutes to find a record.
>
>I added an index to the field that is being used to search, but it
>didn't make a difference.
>
>Is there anything else I can do to speed up the Find process?
>
>
>
>TIA,
>
>Mark Boyd