orm - What are the effects of using object relational mapping on software performance? -


what effects of using object relational mapping on software performance? orm increase performance or decrease it? , differ in various software projects?

it hard question, automatically generated code (orm-code) may slower since orm librares "not clever" developers.

but in way, used orm caching "fast enough" , should not care of performance. should care of instructions use , avoid. should check sql generated orm engine , on "tuning" phase of project can rewrite parts of code of performance not acceptable.

example of performance-killing operation eager loading of collection of object (with 1 many relation).


Comments