jack drawbridge
jackandpat.d at gmail.com
Wed Dec 25 07:27:35 CST 2013
Merry Christmas and Happy New Year to all...! jack On Wed, Dec 25, 2013 at 7:54 AM, Arthur Fuller <fuller.artful at gmail.com>wrote: > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >