Re:Many small queries are efficient in SQLite
by mumblemumble on Tuesday February 16, 2021 @10:35AM
(#26154819)
Tangentially - it may be their problem, but I hesitate to say it's their fault. I'm continually dismayed at how spotty and superficial education about how to use an RDBMS can be. Even in formal education on the subject.
[ Parent
| on HN ]
Re:Many small queries are efficient in SQLite
by FpUser on Wednesday February 17, 2021 @04:56AM
(#26164674)
It does not take PhD and rocket science for one to figure that sometimes operations must be bunched and executed with success/failure as a single unit. That would come as a business requirements. For curious person it would not take much to do some search on a subject and discover and read about transactions.