2 ms·
You gotta love both. I just use ORM for OLTP and raw SQL for OLAP (Better for being more expressive). Migrations saves a lot of time.
by qatanah 7y ago
You gotta love both.
I just use ORM for OLTP and raw SQL for OLAP (Better for being more expressive).
Migrations saves a lot of time.
- tatersolid 7y agoOne problem I’ve seen is that most non-trivial apps have both OLTP and OLAP elements in the same places. Think of how many “mini-dashboards” you see sprinkled throughout the UI of a modern CRM. ORMs are generally not good at or even capable of efficient set-based operations spanning entitles. Building a dashboard with an ORM results in pain and wildly oversized DB instances in my experience.