<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=609314019-01042003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of
</B>MartyConnelly<BR><B>Sent:</B> April 1, 2003 2:01 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] SQL vs DAO --
rattling cages<BR><BR></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">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 :<BR>Declare Function SQLSetConnectOption Lib "odbc32.dll" (ByVal
hDbc As Long,<BR>ByVal fOption As Integer, ByVal vParam As Long) As
Integer<BR><BR></BLOCKQUOTE></BODY></HTML>