Occassionally, I have a need to load the entire record set of a SQL table that has over a million records using a VIEW. Obviously, I normally use parameterized views and only search for record(s) that meet a certain condition. However, recently while waiting for the 1M records come accross the LAN into a local cursor (view), I issued a "GO BOTTOM" command while the view was still importing records. I was shocked that the counter at the bottom of the VFP screen keeping track of the records coming accross the wire kicked into "over-drive." The throughput of this import easily, doubled or maybe even tripped.

Does anyone know why the records were brought into the view so much faster after issuing the "GO BOTTOM" command? Are there any dangers in doing this to speed up the load time of a huge record set?

Thanks,
Robert