Hi,
>>It seems to me that since there is such a big difference between the 10 full and 100 full setting, it is a network issue. Since the whole table is about 2Mb ++, it should take about 2 a 3 seconds to drag the whole table accross the network. Since half of the table was returned (with the help of the index) it should take about 1 a 2 seconds. On a 100 mb network the whole action should take only a fraction of a second.
Sorri, my application takes 4 seconds to query 5,000 records in 100 MB network, and take 1 minutes and more in 10 MB netowrk.
Any ideas?
Sorri, if I am too troublism.
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...