Solved

how to reduce database call on saving the records

Posted on 2011-09-28
1
219 Views
Last Modified: 2012-06-27
I have multiselect list for properties on my asp.net page which allow user to select some option and save it in a database.
Now the table structure is like this UserID and PropertyID.
Now, when I am saving this info currently I am running a loop and executed a single insert SP at a time.
Which surly makes the database call again and again.

I need to know is there any other way of doing these sort of task with minimum database calls

0
Comment
Question by:ziorinfo
1 Comment
 
LVL 12

Accepted Solution

by:
jagssidurala earned 125 total points
ID: 36718682
we can achive this with Sql2008 feature called 'Table Valued Parameters'

Refer these links

http://msdn.microsoft.com/en-us/library/bb675163.aspx

http://www.sqlteam.com/article/sql-server-2008-table-valued-parameters
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now