[AccessD] SQL vs DAO -- rattling cages

Arthur,

M$ must believe it, since their mantra is to add layers of connections.
<VBG>


Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Tuesday 2003 Apr 01 13:43
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] SQL vs DAO -- rattling cages

Not to dispute your reasoning from days of yore, but somehow I cannot
believe that _anything_ is faster than direct calls to the server. Going
through layers of DAO etc. or even the WinAPI has got to be slower than
punching the server. Otherwise layers are insignificant, in which case
the corollary may be that the more layers the better... and I just can't
see my way to that conclusion.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: April 1, 2003 2:01 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL vs DAO -- rattling cages


I have heard of a faster way especially for Bulk  ADDs or DELETE's, with
about a 5 to 1 increase in speed in certain cases, using ODBC API driver
calls directly and turning SQL_AUTOCOMMIT off. using :
Declare Function SQLSetConnectOption Lib "odbc32.dll" (ByVal hDbc As
Long,
ByVal fOption As Integer, ByVal vParam As Long) As Integer