[AccessD] Filter versus select in ACC2002

David,

I think you are on the right track.  I would suggest setting up a loop to do
this 1000 times each of the two different ways.  Set a starttime variable at
the beginning of the loop and an endtime variable at the end of the loop,
then subtract to see if there is a time difference for the two different
methods.

I did this test once and found out that CurrentDB is 8 X slower than
DBEngine(0)(0) for creating recordsets.  (But you must use CurrentDB for
some situations.)

Best of luck!
Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Fenton
Sent: Wednesday, March 03, 2004 6:29 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Filter versus select in ACC2002

Hello all,
I am having a speed problem with one of my Access 2002 applications
FE/BE (not SQL Server) and I started wondering about whether I was
approaching the filtering properly or not, so I seek advice.

Users currently use a search screen to find a record. The main form that
displays the information has a recordsource that selects all records.
The main form is filtered to the record they want based on the results
from the search form. I think I am doing it all backwards and should in
fact select only the record they have searched for, rather than
filtering.

There are quite a few subforms on this form under tab controls and a
control on one of the subforms loads another form which contains many
subforms. The loading of this screen exhibits the same speed problem
because again the form's recordsource selects all records and when the
user clicks to load it, it filters to the correct record. 

Am I putting undue strain on the network by having the form select all
records then filtering instead of just selecting the record they want? I
imagine that the FE form requests the data, which travels across the
network and is then filtered, is that correct? If I change the
recordsource to select only the record they want, then no filtering
needs to take place and I am thinking that the form loading will be
faster...

Any hints, tips, comments, suggestions??

Cheers
David
Australia
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com