>You are assuming the user needs to look at the records directly, but that is not the only way, it is possible you need that million records to build a 3D object representation to display in the screen, or to plot a graph which is at what the user will look

With a million data points?

In which case you can easily stream the data a record at time, no?

+++ Rick ---


>
>
>>And why would you???
>>
>>Who's going to look at 1,000,000 records? On screen or in print?
>>
>>Database 101 - only pull what you need and no more...
>>
>>+++ Rick ---
>>
>>>>Just benchmark retrieving 1 million records from SQL server and you'd stop there...
>>>>
>>>>Not to speak for Rod, but my guess is that he's talking about retrieving a subset, not the entire thing...
>>>>
>>>>Kevin
>>>
>>>Should be. From his words 'after retrieving...' I sensed he meant it. VFP can do that but .Net:(
>>>Cetin