Mark Boyd
MarkBoyd at McBeeAssociates.com
Thu Feb 19 12:48:14 CST 2004
Great. Thanks again Karen. Mark -----Original Message----- From: Nicholson, Karen [mailto:knicholson at gpsx.net] Sent: Thursday, February 19, 2004 1:19 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Faster Searching Right click on the button. It gives you a little blurb that if a date is formatted as Jan - 1 - 2000, this option would look for the J not the 1/1/2000. Notes that searching with as formatted is dreadfully slow. -----Original Message----- From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] Sent: Thursday, February 19, 2004 1:07 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Faster Searching 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 _______________________________________________ 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