🚀 go-pugleaf

try add this line:

AdoDataSet->CursorLocation = clUseServer;



"Georgi Cholakov" <georgi.cholakov@mail.bg> wrote:
>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
>
>
>
>