[dba-SQLServer] Faster Searching

Also, make sure you only check one box on the filter by
form defaults.  The more you check the longer it takes to process.

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com]
Sent: Thursday, February 19, 2004 12:52 PM
To: SQLServerList
Subject: [dba-SQLServer] Faster Searching


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

Sr. Systems Analyst

McBee Associates, Inc.

 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com