I am experimenting with DO SQLite and it's a real charm so far ! I however can't find a clear answer
I am experimenting with DO SQLite and it's a real charm so far ! I however can't find a clear answer on how to use SQL transactions with SQLite and if it may have a signifiant impact on performance for tables with few thousands of rows. A user may insert or update up to 200 rows at the same time.
Since it's BETA, there is still no clear example in the docs for SQLite
And a tutorial that inserts 60 rows says : "Since SQLite in DOs is fast, we can do a query per INSERT instead of batching them in a transaction."
Since it's BETA, there is still no clear example in the docs for SQLite
And a tutorial that inserts 60 rows says : "Since SQLite in DOs is fast, we can do a query per INSERT instead of batching them in a transaction."
