Sterling DB vs SQL CE in Windows Phone Development

20 February 2012

Just a quick note for everyone weighing up between Sterling DB and SQL CE for your Windows Phone app - while Sterling DB is fantastic for small sets of data, it performs very, very poorly with bulk inserts / restore (a few minutes when we hit the hundreds of rows mark), which makes it unsuitable for any large tables. The SQL CE support in Mango, while slightly slower on queries, is much more consistent and more suited to larger data sets.

Hopefully the team behind it improves the performance in the future, because it's really lightweight and easy to program against; but for now would warn against using unless you want to spend a day replacing your DB layer like I did...

If you're looking to get started with SQL CE, this guide at Windows Phone Geek is a good place to begin.

Tags: SQL CE, Sterling DB, wp7

Add a Comment

No Comments