Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Can anybody shed some light on how these SQL products compare? No need for essays, only highlights such as "X supports this, while Y doesn't".

  • How is efficiency affected as the database grows larger
    • Inserts
    • Updates
    • Selects
  • What kind of transactions are supported
  • What support is there for multiprocessing
    • Access from concurrent processes
    • Access from concurrent threads
  • Data access is in-process or via server process
  • Key feature of either product that is worth mentioning

Also, any (positive or negative) experiences from people who have used both products (don't want opinions - just observations).

The reason I'm asking is that it's hard to penetrate the marketing fluff surrounding Microsoft's embedded SQL product.

Thank you.

share|improve this question
1  
Please be more specific about your particular requirements - this is a very broad question as it stands –  Jack Douglas Aug 17 '11 at 8:24
    
The last bullet is somewhat broad, but I want to capture people's experiences with the products. What is marketed is not always reality... –  Jörgen Sigvardsson Aug 17 '11 at 9:04
add comment

1 Answer

up vote 4 down vote accepted

Based on your question "What support is there for multiprocessing":

  • SQL Server CE and SQLLite are single-user DBs that work in your app and deployed as DLLs
  • SQL Server (Express and above) (and MySQL, Oracle, Postgres et) are server engines where you submit a request

Either you have proper multiprocessing or you don't: not much grey area in between. The rest of your questions don't matter because of this.

An as example, SQLLite locks tables locking so you don't have much concurrency even if it nominally supports multiple processes

Edit, about SQL Server CE from SO

It looks like SQL Server Express is recommended for multi process access

share|improve this answer
    
I know SQLite responds with a generic "it's locked" response, if a second process wants to access the data concurrently. Would SQLCE do the same, or is it possible to have the calling process be put in a wait state? –  Jörgen Sigvardsson Aug 17 '11 at 10:06
    
@Jörgen Sigvardsson: added more –  gbn Aug 17 '11 at 10:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.