Using the ADO Filter Function
Written by Eric Smith, Northstar Computer Systems LLC
A reader recently wrote in complaining about the lack of speed of the ADO Filter function. He was filtering records in a 720 Mb Access database and was trying to figure out how to speed things up. I have a couple of suggestions. First of all, build a query based on your criteria, even if the query has to be sent in directly instead of as a stored procedure. It will run much faster than your Filter function ever will. Secondly, for that large of a database, I’d suggest upgrading to SQL Server. It has many performance improvements and includes features for searching text fields more efficiently, such as the Full Text Search feature.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 3/1/2000
|