Re: SQLCE work with other databases?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Mike,

I didn't take that approach for a couple of reasons. The main reason was that I never wanted the whole table. That's actually pretty common with mobile apps - you just want a subset of the enterprise data on them no matter what technology you use on both layers. I aso wanted to massage the data a bit and in some cases de-normalize it for better performance on the device, so the tables in the SDF file don't match those on the desktop precisely.

And the second reason is that even if I could bulk dump the data from the DBF files that would be faster than extracting it record by record, there's no fast bulk insert for SQL Compact for loading it. You can improve performance, if it's an issue, by not building the indexes until after you load the data and by loading the data in transactions that are some group of rows > 1 and less than a whole table, but that's about it. The biggest performance gain overall for my customers was giving them the option to build and download new SQL Compact tables from reference data that changes infrequently only when they choose to do that while still allowing them to upload the relatively few inserts and updates while that data is fresh.

--
Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Scalehouse and Billing Software for Waste Management



<fodsuk@xxxxxxxxx> wrote in message news:7e967f5c-9064-4a7d-97f7-d1e4e3cf2785@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello Ginny,

I have had my head buried in a sample app
hence the lack of replies :).

Rather then going through the DataReader route of reading
each row of results.

did you look into doing some sort of Extract and Dump the results as a
table
into the Sqlce database?

from my premiliary research it doesn't seem possible, did you come
across this?

Kind Regards,

Mike

.

Relevant Pages

  • Re: Llllarrry caught on audio
    ... " Extracting the ... only meaningful thing you wrote-- while deleting the silly garbage. ... Which, of course, is the reason I remain the undisputed KING of RSG. ...
    (rec.sport.golf)
  • Re: Llllarrry caught on audio
    ... " Extracting the ... only meaningful thing you wrote-- while deleting the silly garbage. ... Which, of course, is the reason I remain the undisputed KING of RSG. ...
    (rec.sport.golf)
  • Re: Llllarrry caught on audio
    ... " Extracting the ... only meaningful thing you wrote-- while deleting the silly garbage. ... Which, of course, is the reason I remain the undisputed KING of RSG. ...
    (rec.sport.golf)
  • EIF MSI Package
    ... I would like to have just the MSI package to install. ... Is there an easy way of extracting this from the current .exe? ... The reason for this is that I would like to do automatic deploys to dozens of servers. ...
    (microsoft.public.vsnet.enterprise.tools)
  • Re: Server randomly rebooting due to bugcheck
    ... So it always fails for the same reason or is it more random ... Has anything been done to the server lately - new HW, patches, updates? ... Loading Kernel Symbols ...
    (microsoft.public.windows.server.sbs)