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
>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
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges