🚀 go-pugleaf

Hi,
        It is faster to use a prepared parameterized statement for fast
loading data into a data source. Send multiple sets of parameters instead of
one-by-one. See the samples OleDBExcel and MultiProcs at www.udaparts.com.
If your backend is SQL server, you could use IRowsetFastLoad. See the sample
FastLoad.

--
Yuancai (Charlie) Ye
Use of free SocketPro package for creating super client and server
application,
See 30 well-tested and real OLEDB examples
at http://www.udaparts.com


"Christian Schneider" <csname@hotmail.com> wrote in message
news:3d16bf57$1_1@dnews...
>
> I just want to add a record to a table. I am now
> using something like this:
>
> AdoDataSet->CommandText = "SELECT * FROM Customer";
> AdoDataSet->Open();
> AdoDataSet->Insert();
> AdoDataSet->FieldByName(...) = ...
> AdoDataSet->Post();
> AdoDataSet->Close();
>
> The problem is, that Open() can take very long if the
> table is large. It would be much faster to use an
> "INSERT INTO"-Statement, but I can't use it because
> my record contains BLOB-Fields.
>
> It there really no other way to just add
> a record to a table without waiting several seconds?
>
>
> Christian Schneider