Live to tell about it!
Thanks god is Friday! Time to breath some fresh air, go out and do some hike.
Want to see my last known position? Check this out:
http://share.findmespot.com/shared/faces/viewspots.jsp?glId=0fsO8qVuo7rat0EBdioLWddeqUvKpLeMk
See you out there!
Off Topic:
- Should I use an ORM tool like SubSonic, nHibernate, or .netTiers? Which one of these have the best performance? I am current using bare DataReaders (which are lighting-fast), but I am sick of updating the DAL components with every change in the DB. Should I stay or move? Now or never..
- Remember the performance benefits of using SPs vs Inline-SQL? Well, since SQL 2K both methods have pretty much the same performance! Both are compiled by the DB engine. Did you know that?? Check this.
- Building a quick-n-dirty Web app to CRUD the data of the H Initiative. Playing with GuidViews, DetailViews and SqlDataSource controls, knowing their pros/limitations.
- I finally got my Windows Azure and SQL Azure test accounts. Time to current iteration the H Initiative in the clouds.
Jaime Tarquino
Well , sorry to give you bad news but the SPs and the in-line SQL doesn’t has the same performance, actually in SQL 2005/8 there are new options in the server to help the in-line (more known as stament in the SQL World) things like FORCE_PARAMETERIZATION option and the plan guides which y to improve the performance of applications based in the stament/dynamic SQL approach, so the SP still being the way to go if you are looking for performance, easiest optimization and increased security to avoid the sql-injection
Dec 15, 2009 @ 22:34
Ernesto Marquina
SPs, in most cases will always be more efficient performance-wise. Although that has the tradeoffs we all know. ORMs freaking rock. You can have the best of both worlds on mapping objects directly to SPs, Views or even functions. Not all ORM frameworks supports this but I had good experiences with nHibernate.
In sum, an ORM framework with good performance is the one that has a good caching mechanism.
Dec 23, 2009 @ 00:43
Jose Parra
Some other articles about this subject:
http://www.simple-talk.com/sql/t-sql-programming/to-sp-or-not-to-sp-in-sql-server/
http://bloggingabout.net/blogs/adelkhalil/archive/2008/01/06/the-myth-of-stored-procedures-preference.aspx
Mar 04, 2010 @ 12:20