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