3 ms·
> performance Performance is usually better in the database, because the data is local. However, like any language, there is more than one way to say it in SQL
by combatentropy 8y ago
> performance
Performance is usually better in the database, because the data is local. However, like any language, there is more than one way to say it in SQL. When the query is complicated, with joins and subselects and aggregates, I have made it literally a thousand times faster by rearranging and rewriting things. I'm not even talking about adding indexes yet.
> scalability
I think 99% of applications could scale just fine with Postgres.