Re:Cold Showers: For when people get too hyped up about things
by barrkel on Friday July 24, 2020 @02:01PM
(#23942587)
You've just moved a bunch of problems to whatever is accessing SQLite. How do you scale out the application server compute if it needs to make transactionally conditional updates?
E.g.:
transaction {
if (expensiveFunction(query()))
update();
}
(My applications always get much faster when I plug them into Postgres after SQLite. But then I do do the odd sort and group by, not OLAP, but because they express the computation I want and Postgres is simply much better at that.)
E.g.:
(My applications always get much faster when I plug them into Postgres after SQLite. But then I do do the odd sort and group by, not OLAP, but because they express the computation I want and Postgres is simply much better at that.)