[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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030401/59c3bee9/attachment-0001.html>