>
>I see. I doubt that you could slow down SQL Server (if you have right indexes). Now I could get 4000 records for less than a second (LAN). Never tested it in WAN.
>Also all depends how big is the record size 10 000 * 100 bites record size is nothing, but 10 000 with 8 000 bites record size is more almost 80MB transfer.
>But you should test the worst scenario you can thing of, just to be sure.
I think most likely I will get just the key/id column of the table, which obviously has an index tag. So there will be small record size.
Thank you and Sergey for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham