News for hackers. Stuff that matters.
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.
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.