Lazarus

Programming => Databases => Topic started by: Pascal on June 13, 2019, 01:26:41 pm

Title: Is SQLDB able to do array fetch/update/insert?
Post by: Pascal on June 13, 2019, 01:26:41 pm

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

Title: Re: Is SQLDB able to do array fetch/update/insert?
Post by: Thaddy on June 13, 2019, 06:00:03 pm

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.

Title: Re: Is SQLDB able to do array fetch/update/insert?
Post by: Pascal on June 13, 2019, 09:16:14 pm

Are there any samples?

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