using sqlceresultset to insert to SDF from remote SQL connection

  • Thread starter Thread starter Milsnips
  • Start date Start date
M

Milsnips

Hi there,

i've seen examples out there which loop through a counter and insert
"ficticious" data into local tables with good performance, what i'd like to
do is the following (which i have working with remote SqlDataReader object
and looping through it.

1.Connect to remote SQL database via web/network/other..
2. Retrieve a dataset or similar
3. Use SQLCeResultSet to insert these values in the local table.

For now, just testing the remote sqldatareader loop, with no data writing
locally, 4000+ records takes me about 2-3minutes, Any ideas on how i can
speed this up or some small code example would be great.

thanks,
Paul
 
Hi Chris,

I'm actually using both.
the SqlDataReader loops through records from a remote web server (which i
didnt have access to setup replication so using SqlClient to access table
data directly, while in the loop i use sqlceresultset to createRecord and
insert into a table directly.

What i'm questioning is if i grab the remote data first, store it in say a
datatable, then loop through that instead of the sqldatareader, should i see
a further performance increase because its all local?

regards,
Paul
 
Back
Top