I hope this is not a double post, but this was answered in another thread. See http://www.nabble.com/Improving-performance-of-SQLite.-Anyone-heard-of-DeviceSQL--to14280006.html#a14317195
D. Richard Hipp wrote: > > John Stanton <[EMAIL PROTECTED]> wrote: >> I received an email promoting a DeviceSQL web presentation. It >> specifically targets Sqlite and promises 5X performance. >> > > If you view their web presentation and/or try out Encirq's > products, I would be very interested to hear your impressions. > Even better would be if you could blog about it. > > Encirq has for years been running Google Adsense ads claiming > to be 20x faster than SQLite. (Dunno why they have now reduced > that claim to 5x faster.) But I have never yet seen an > independent confirmation of this. Nor even have I been able > to find anybody who is actually using DeviceSQL in a product. > Web searches turn up nothing but marketing literature coming > directly or indirectly from Encirq. Some independent analysis > (regardless of whether it is favorable or unfavorable to SQLite) > would be appreciated. > > My understanding of DeviceSQL is: > > * It is NOT transactional. There is no such thing as ROLLBACK. > * If you lose power during a write, your database is toast. > * If your database schema changes, you have to recompile > your application. > * The database file format changes depending on the schema. > * DeviceSQL is not a general-purpose database engine. You > compile SQL statements into C code on a development > workstation, then compile the C code for your embedded > device. > > I can imagine circumstances where the DeviceSQL approach, > while much less flexible and forgiving than SQLite, might > be a better way to go, depending on what you are trying to > do. But I have not gotten good vibes from Encirq as a > company. And I have no idea how reliable the DeviceSQL > product is. I would really appreciate your thoughts on > that subject. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/DeviceSQL-tp14297970p14327299.html Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------