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
- 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.