> -----Original Message----- > From: Yves Goergen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 26, 2007 4:55 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Introducing... ManagedSQLite > > On 26.06.2007 00:24 CE(S)T, WHITE, DANIEL wrote: > > The main advantage of mine is that it is lightweight and easy to use > > without using ADO.NET. > > Okay, the other SQLite.NET DLL has 592 kB, that's not necessarily > "lightweight". I'd like to be able to include the SQLite library into > the main assembly so that I won't need a separate DLL anymore. I'm not > sure though how good that works with each solution or whether it's a > good idea for other reasons. > > But I'm quite happy with it without using ADO.NET. In fact, I > don't like > the idea of copying each and every record into memory and having it > sorted and filtered there (which ADO.NET propagates) instead of having > that done directly in the source database engine...
The nice thing about ADO.NET (other than all the bells and whistles built on top of it) is that you can decide where you want to process things. If you're using a client/server model and want to process on the client-side, you can use the disconnected model that behaves as you've described. If you'd rather communicate directly with the database and process per-row as quickly as possible, you can use the DbCommand/DbDataReader model. The Command/DataReader model conforms very nicely with SQLite's sqlite3_prepare/sqlite3_step model and is a relatively thin layer on top of it. The 592k desktop version of the library is built for performance using PGO (profile guided optimizations) and includes both FTS1 and FTS2 modules (for now) as well as the ADO.NET wrapper assembly. While some may argue whether or not 592k is "lightweight", it's definitely not in the heavyweight category either. On the desktop, 592k is really considered a pittance. When built to minimize size on the Compact Framework w/o FTS1, the library is only 476kb. Considering the alternative databases available for the Compact Framework, that's roughly 1/3rd the nearest competitor's size. Robert ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
