Click here to Skip to main content
11,718,289 members (89,302 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-server-2005 ASP.NET , +
Hi Guys,

Please assist me how to make my web application faster in huge database records.

I have database having huge records approx 30Lacs records and we are facing speed issue while inserting/updating and SEARCHING. We already implemented normalization,indexes, full text search in SQLSERVER2005/2008 and AjAX, javascript in web.

Please let me know how we can improve the speed of application. Also is there any way in SQLServer2005/2008 to make it faster search/insert/delete operation through web application.

Please also suggest about Partition. Is it helpful to implement over 30lacs records? OR It is not advisable to do that. I do not have idea on partition. Please also comment.

Waiting for your reply...

Thanks in advance.
Posted 29-Apr-13 2:52am
Edited 29-Apr-13 4:09am
Ankur\m/ at 29-Apr-13 9:11am
1st thing would be to check out the query plan of your queries. You say you have everything in place but it is still slow. It seems your indexes are not well designed. Query plan will help you a lot. You may also need to rebuild your indexes based on latest statistics.
learner'sbug at 29-Apr-13 10:31am
I think first step should be to identify the exact issue..Is it DB related for sure ? I came across such issue once and found out that one of the third party control was sending multiple requests to the server which was delaying the CRUD..Try using fiddler for traffic and If you eliminate those issues you can go ahead with OP's suggestions.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 215
1 F-ES Sitecore 210
2 Maciej Los 140
3 Jochen Arndt 120
4 Andy Lanng 115
0 OriginalGriff 535
1 Maciej Los 529
2 Richard MacCutchan 440
3 CHill60 415
4 F-ES Sitecore 415

Advertise | Privacy | Mobile
Web04 | 2.8.150901.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100