dotnet compact framework: Slow loading of sqlce database from sqlserver -- dotnet compact framework

Slow loading of sqlce database from sqlserver

mikeb
2/18/2005 10:34:56 PM

dotnet compact framework: I'm trying to load a sqlce database that resides on my ppc. I'm taking
records from a sql server, loading them into a dataset via a stored prcedure
call, and then cycling through the dataset to load the data into sqlce.

It take a very long time to load from the dataset to the sqlce - is this
what I should expect?

I remember looking into some sync method that was recommended to me a while
back - but since my databases (sqlserver and sqlce) doesn't match exactly I
don't think it woujld have worked.

What is the best way to get data from a sql server stored procedure call
into a sqlce database?

thx, -Mike

Re: Slow loading of sqlce database from sqlserver

João Paulo Figueira [eMVP]
2/19/2005 12:11:39 PM

SQL CE is notoriously slow when inserting data through a SQL command (even a
parameterized and prepared INSERT command will be slow). The best approach
for bulk inserting is using a base table cursor through the OLE DB layer,
but this is not readily available to the CF (I'm working on it). I have been
working on the subject of porting data back and forth and you can find some
products that may help you on my site - www.primeworks.pt

--
João Paulo Figueira
Embedded MVP

[quoted text, click to view]