[dba-SQLServer] Faster Searching

Mark Boyd MarkBoyd at McBeeAssociates.com
Thu Feb 19 12:07:12 CST 2004


Thanks Karen.  I tried all of your suggestions, but the search is still
very, very slow.
I noticed a checkbox on the Find and Replace dialog box that says
'Search Fields As Formatted'.  By unchecking this, the search takes
about 2 seconds.  What does this checkbox mean?

Mark

-----Original Message-----
From: Nicholson, Karen [mailto:knicholson at gpsx.net] 
Sent: Thursday, February 19, 2004 1:01 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list