Tuesday, January 30, 2007

Stored procedure or Object relational mappings?

Nowadays, software applications use databases extensively while finding the right method is not that easy, problaby because there are so much choices out there. So, Stored procedure or Object relational mappings, ORM? Simple, use store procedures when scaleability is highly concerned. On the other hand, when you want to achieve the highest development productivity, use object realational mappings. How about data access performance? With today technology and tools, performance between the two has not much significant different, however stored procedures method is believed to have a better performance. Security? Recently, ORM method has becoming the most popular choice for developers. Well it all depends on your code implementation. For me, i use ORM such as Dlinq.

No comments: