🚀 go-pugleaf

Hi, Christian
I saw the recommended tricks, but in my modest opinion they are useless or
difficult to use. I think the reason for delay is in your SELECT statement,
because you first select all the data from the table Customer and then
insert a new record. If you optimize your select to return a small number of
records the delay will be minimized.
Try this: "SELECT * FROM CUSTOMER WHERE CUST_ID = 0" for example, where
CUST_ID is the name of the primary key. This statement will return no
records and it will be fastest & simplest way for your case.

Georgi Cholakov

"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