[AccessD] Which is faster DAO or Append Query? (in this case)

Steve Schapel steve at datamanagementsolutions.biz
Tue Dec 24 13:38:20 CST 2013


5-10 seconds is a long time, Rocky.  Hard to imagine that this is solely 
caused by network data transfer.  How many records are we talking about 
here?

Regards
Steve

-----Original Message----- 
From: Rocky Smolin
Sent: Wednesday, December 25, 2013 3:31 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Which is faster DAO or Append Query? (in this case)

The delete is a simple db.Execute "Delete * FROM tblX"

The append doesn't have any aggregate or domain functions.  When I run it as
a select query it pops right up.

But I'm running FE & BE local and I think the problem may be bringing all
that data across the wire in his place.

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Tuesday, December 24, 2013 3:35 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Which is faster DAO or Append Query? (in this case)

Hi Rocky

How are you running the Delete and Append queries?

Do either of the queries that are behind your append query contain
user-defined functions or nested domain aggregate functions or anything that
causes them to run slowly?  If you change your append query to a select
query, and run it, do you notice any sluggishness as the datasheet loads
your records?

Regards
Steve

-----Original Message-----
From: Rocky Smolin
Sent: Friday, December 20, 2013 5:16 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Which is faster DAO or Append Query? (in this case)

Dear List:

I have a form which is bound to a temp table.  When the form is opened, the
temp table records are deleted and re-created with an append query - two
tables and two queries linked up.  It appends 36 fields.

The user reports 5-10 seconds delay opening the form and it is due, AFAICS,
to the append query.

I have always done a lot of stuff in DAO and find it to be easy to write and
fast in its operation.  So I could do this in DAO but would it be any
faster?

MTIA

Rocky







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

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

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



More information about the AccessD mailing list