[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