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

Arthur Fuller fuller.artful at gmail.com
Wed Dec 25 06:54:46 CST 2013


I loved Ender's Game (the book) that I've been afraid to see the movie. How
was it?


On Wed, Dec 25, 2013 at 12:55 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> We went to see Ender's Game this afternoon and then a big sushi feast.
> Tomorrow some family coming over and we're going to spatchcock a turkey!
>
> Merry Christmas to all...
>
>
> r
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
> Sent: Tuesday, December 24, 2013 3: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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur


More information about the AccessD mailing list