March 15, 2005 at 10:54 pm
I am developed a package in VB/SQL Server. After entering morethan 2 lakhs of data, the retrieval of database becomes slow eventhough it is indexed on necessary tables. How to solve this problem? - Krish
March 16, 2005 at 4:12 am
First, it is better to post this kind of questions in the performance forum.
There are lots of possibilities. The most obvious is "do regular update statistics", automatic or throught a maintenance plan.
If that does not work, you will have to check the used execution plan. Check why the retrieval is slow. It might be something on the client,server or network. Whole libraries are written on the subject and you do not give much information.
BTW, what is a lakh?
Joachim.
March 17, 2005 at 5:08 am
I think this equates to what we call 100,000.
LP
LP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply