[AccessD] ...building, managing, and using a page favorites list

Jim Dettman jimdettman at verizon.net
Sun Mar 8 20:18:58 CDT 2009


Max,

<< I *like* the sql because
it is just a one/two liner and not a block of code.>>
 
  That's what subroutines are for ;)

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Sunday, March 08, 2009 2:45 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] ...building, managing, and using a page favorites
list

Thanks Gustav, I guess it is the opening of the recordset which takes the
time and by holding it open in a loop it will beat the sql statement every
time. But nice to get this confirmed.

As you say, for one record it makes no difference.  I *like* the sql because
it is just a one/two liner and not a block of code.

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 08 March 2009 17:19
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] ...building, managing, and using a page favorites
list

Hi Max

No. Working with the recordset directly via DAO is always fastest - but many
forget or carry over their bad habits from VB or ASP where you see so much
SQL command stuff and the like, because this once was the only - or at least
the easiest - method available in those environments.

Of course, for a single record inserted, difference will not be big. But can
you keep the recordset open, one insert is very speedy.

/gustav

>>> max.wanadoo at gmail.com 08-03-2009 17:24:53 >>>
> This speeds things up by keeping the recordset open the whole time.

Would it be quicked to use an SQL statement ie,
Sql = "Insert into tblAudit fields(x,y,z) values (a,b,c)
Currentdb.execute(sql)

Rather than opening recordsets.  I don't know, so i am really asking the
question

Thanks

Max



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