This function allows you to disable the request of the number of affected rows after executing INSERT/UPDATE/DELETE/MERGE statements. This will improve performance when executing a lot of updates/inserts in a cycle for example.

Syntax

 function ibec_SetConnectionProp(Connection : variant, PropertyName : string, Value : variant);

Example

 execute ibeblock
 as
 begin
   execute statement 'CREATE TABLE TEST_INSERT (ID  INTEGER)';
   commit;

   TimeStart = ibec_GetTickCount();
   for i = 1 to 10000 do
   begin
     insert into test_insert (id) values (:i);
   end;
   TimeEnd = ibec_GetTickCount();
   Time1 = TimeEnd - TimeStart;
   commit;

   execute statement 'delete from test_insert';
   commit;

   ibec_SetConnectionProp(ibec_GetDefaultConnection(), 'GETROWSAFFECTED', FALSE);
   TimeStart = ibec_GetTickCount();
   for i = 1 to 10000 do
   begin
     insert into test_insert (id) values (:i);
   end;
   TimeEnd = ibec_GetTickCount();
   Time2 = TimeEnd - TimeStart;
   commit;

   ibec_ShowMessage(Time1 || '       ' || Time2);
 end

back to top of page
<< ibec_RestoreDatabase | IBEBlock | ibec_GetConnectionProp >>