meta data for this page
ibec_SetConnectionProp
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.
Description
No additional description…
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