>Hello again
>
>Which is better suited for transfer data from one foxpro DBF to another foxpro DBF, DataSet or DataReader.
>
>I'm trying to decipher
>
>DataView catView = new DataView(catDS.Tables["Categories"]);
>
>
>How do you define/create
catDS.Tables portion and how does this relate to DataSet or DataReader?
>
>TIA
I would go with a DataReader and parametrized insert command.
I've made some tests regarding inserts from a SSE 2005 database to DBF and to SQL Server Compact Edition
The table was 100k rows and 150 row length and the test was local only.
I don't know if I'm permitted to show results here (EULA, even if the test cannot be named a "benchmark"), but seems that SqlServer CE is a clear winner if we are using a DataReader to read data from SQL Server 2005 and a SqlCeResultSet + SqlCeUpdatableRecord to insert data in destination database. It is much, much faster than VFP through OleDB. And VFP inserted data in 6s.600ms ;)
Another advantage of SqlCe is that it has SqlCeResultSet , which is somehow similar with a VFP cursor ( updatable, scrollable ). I was able to show those 100k rows in UI in 1 1/2 sec (one second).
For comparison, only loading into a DataSet from SSE, without actually insert something, takes 30seconds, even if the DataReader "scan" through 100k rows is only 600ms.