My Life As A Blog


leave a comment »

I know of many, myself included, that switched from these stored proc based systems to using O/RM without stored procs, but I know no one that switched the other way

observes Paul Wilson in a recent post.  I’ve had positive experiences with ORM tools, especially NHibernate – although for some the mindset change required can be a significant barrier – and I’ve worked on systems where stored procedures were a real problem (especially in terms of maintenance, versioning and performance.)  The debate about ORM versus traditional data access techniques strikes me as a variation on the debate on managed memory versus unmanaged.  Once you’ve lived in a managed world, you’d be reluctant to go back to an unmanaged one – but it doesn’t mean you stop paying attention to memory issues.  Similarly, when you use an ORM framework, you should still be aware of how it works and what the impact of your decisions are.


Written by remark

June 4, 2006 at 4:56 pm

Posted in Design, Software, Tools

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: