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

Tony Septav TSeptav at Uniserve.com
Tue Dec 24 17:52:25 CST 2013


Hey All
I just do not get you guys. Yes saying Merry Christmas And a Happy New Year
may sound superfluous but hey it is time to celebrate with what ever means
we have. Shame on you bunch of geeks. This is the time to smile, whether bad
or good. And I doubt it but I hope it snows tomorrow.

Tony Septav
Nanaimo, BC
Canada

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: December-24-13 1:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Which is faster DAO or Append Query? (in this case)

About 1200.

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 11:38 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Which is faster DAO or Append Query? (in this case)

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 

--
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