how to solve this issue for performance issues.

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

Latest Posts