Click here to Skip to main content
12,997,210 members (75,423 online)
Rate this:
Please Sign up or sign in to vote.
See more: , +
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
Updated 29-Apr-13 4:09am
Ankur\m/ 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170622.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2017
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