[AccessD] fastest way to execute sql

Mark,

The fastest way is to have your server execute it using pass through SQL.
You should NEVER pull millions of rows into Access for processing.  That is
crazy.  It is not designed to do that.

Once you have the pass through query defined, you can use it as a data source to
append data into a table on the Access side, but don't even think about doing
millions of rows.

Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge


Quoting accessd-request at databaseadvisors.com:

> Date: Thu, 13 Jul 2006 15:15:26 +0000
> From: "Mark A Matte" <markamatte at hotmail.com>
> Subject: [AccessD] (no subject)
> To: accessd at databaseadvisors.com
> Message-ID: <BAY121-F8F0B3D7A50E6847BC8D9FD26E0 at phx.gbl>
> Content-Type: text/plain; format=flowed
>
> Hello All,
>
> In A97 or A2K is there an speed advantage in using different methods of
> executing SQL...runsql vs openquery vs CurrentDb.Execute vs qdfCurr.Execute
> ....or any other method of getting the data.  I'm pulling millions of rows
> from informix via odbc and appending within Access...the whole point of this
> is I need to do some wildcard searches on a number of memo/blob fields...and
> need the records local or it times out.
>
> So...bottom line...whats the fastest way to get data from informix via odbc
> into an access table?
>
> Thanks again,
>
> Mark A. Matte
>
>
>
>