2 ms·
The things that no-one seems to know about from ORMs are: 1. Stored procedures. the idea that you treat your SQL like other code, and put it in sprocs, paramet
by marcus_holmes 11y ago
The things that no-one seems to know about from ORMs are:
1. Stored procedures. the idea that you treat your SQL like other code, and put it in sprocs, parameterise it, version it, etc.
2. Optimising tables and playing around with different normal forms and indexes to get the best results. Database design, basically. The 1:1 Object:Table mapping that ORMs use is not always optimal.
3. Indexing multiple fields that get queried together. If you commonly query on user name and state, then create an index for that. Maybe. If that table is read from more than it's written to. If read time optimisation is more important than write time optimisation.
I haven't looked at a SQL tutorial recently, so I can't help with that, sorry