Click here to Skip to main content
Rate this: bad
good
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 3:52am
Edited 29-Apr-13 5:09am
v2
Comments
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 6,803
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,421
3 Manas Bhardwaj 4,841
4 Maciej Los 4,330


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2014
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