how to solve this issue for performance issues.

Posted by Jayakumars under ASP.NET on 4/18/2012 | Points: 10 | Views : 1167 | Status : [Member] [MVP] | Replies : 2
hi

I have recoreds 500 records in my dataset then i insert every time
pass this dataset to my datalayer there using for loop to insert for this
so this process someting performance issues comes how to reach insert quickly
without performance issues

Mark as Answer if its helpful to you


Responses

Posted by: Gsm_Gsv on: 4/18/2012 [Member] Starter | Points: 25

Up
0
Down
Use N-tier architecture, so that you can improve the overall performance. And implement the concepts of unity container, dependency injection and iBATIS.

Refer this site
http://dotnetninja.wordpress.com/2008/05/14/dependency-injection-with-unity-and-aspnet/

---------------------------------------
Live the life you've dreamed

Regards
MADHU

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajni.Shekhar on: 4/18/2012 [Member] Bronze | Points: 25

Up
0
Down
everytime you hit the database like for 500 time are your hitting the database to insert the records?????

If so, then concatenate all insert queries in string builder using some delimeter. and in procedure lavel, split all insert queries and execute it.

Thanks,
Rajni Shekhar

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response