Brad Marks
BradM at blackforestltd.com
Tue Dec 24 19:25:56 CST 2013
Tony, Tons of extra snow here in Minnesota. I will send some out to you as an email attachment as soon as I figure out how to do so. Merry Christmas Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Tony Septav Sent: Tue 12/24/2013 5:52 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Which is faster DAO or Append Query? (in this case) 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=74E0A28C36.214FD