[dba-SQLServer] Faster Searching

Replace a search against a linked table with a search either against a
function or a stored procedure, using pass-through query.



Robert Djabarov
SQL Server & UDB
Sr. SQL Server Administrator
Phone: (210)  913-3148
Pager: (210) 753-3148
9800 Fredericksburg Rd. San Antonio, TX  78288
www.usaa.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark
Boyd
Sent: Thursday, February 19, 2004 11:52 AM
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