Access or SQL CE??

  • Thread starter Thread starter BGD
  • Start date Start date
B

BGD

How does SQL CE compare to Access databases on a PocketPC? I have done
simple operations such as opening the Northwind - Order Details table (2155
records) using both Access and SQL CE on my iPaq and Access can open the
table <1 second, where SQL CE takes 6 seconds the first time and then 10+
seconds anytime afterwards. I am using the Query Ananlyzer on the iPaq for
SQL CE and a custom app for the Access database.
Is this how well SQL CE performs? If so then the speed will probably not
be acceptable. I like the security features in SQL CE but if it is 5-10
slower than an Access db then I probably will have to stick with Access.

Thanks
 
If you are using the Compact Framework, then you can't use Pocket Access
unless you use a wrapper like IntheHand adoce. Sql CE isnt' the fastest
thign in the world and from my experience, opening and closing connections
can be quite slow. However, you don't really need with as a back end in
that you can serialize your datasets to XML and then deserialize and update
using SqlClient for example To that end, I didn't really notice much of a
difference between SqlCe and Access and you can certainly do a whole lot
more with CE. You may want to pick up Rob Tiffany's Sql SErver CE book
though if you go with CE -- it's a great resource.

HTH,

Bill
 
Back
Top