> Hi Johan,
> That's useful information. Access is very slow, of course.
Yes, was merely trying to give an idea of speed. Even in that scenario it was acceptable for the quantity of data that had to be "exported".
> And of course SQL Server can hold a table in memory also. The question relates to what happens
> on the client side with a 2GB cursor retrieved from SQL Server, compared to VFP optimized for the same query.
> This is rarely an issue except in reporting where the data has to be munged before the report engine, whichever, runs.
Hank,
It will be managed by the OS to swap to disk when required. Reports are definitely a concern, however I have not yet seen anything posted on the X# forums regarding "out of memory" issues found yet by anybody working with large datasets.