Is SQLDB able to do array fetch/update/insert?
lazarus / 16-Databases

----------------------------------------------------------------------
Pascal · 2019-06-13 11:26

Is SQLDB able to do array fetch/update/insert to improve performance?

----------------------------------------------------------------------
Thaddy · 2019-06-13 16:00

Of course, but you have to do that in SQL, not Pascal.
Reason: SQL is more efficient on the underlying database operations.
Pascal would call the SQL engine anyway (in a loop).
Note not every SQL db supports this, so it is also dependent on which
database you use.

A simple strategy is to use a TBufDataset and when finished commit to
the database.

----------------------------------------------------------------------
Pascal · 2019-06-13 19:16

Are there any samples?

20 years ago i used DOA (Allround Automations) for Delphi, which was
able to do array DML with Dataset component.