Please assist me how to make my web application faster in huge database records.
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.