Hello Robert,
On Wed, March 22, 2006 15:32, Robert Simpson wrote:
...
> I can't vouch for its performance since I've never actually used it.
we're using SQLite under WinCE since version 2.1.7, with excellent
performances. We have been able to handle database with more than 100000
records and up to more than 15 Mb without much problems. Most of the times the
programming language is the bottleneck, with queries executed in no time and
most of the computing time spent filling grids, combo boxes and so on. SQLite
rocks also when it comes to reliability, with almost no data loss despite the
problematic mobile environment.
We haven't tried the recent 3.X version yet, but 2.8 works like a charm, both
with the old Embedded Visual Tools environment and the newer .NET Compact
Framework. BTW we're not using the .NET data provider but direct calls to a
DLL that wraps SQLite so that it is usable from the development languages we
use.
Bye,
--
Denis Sbragion
InfoTecna
Tel: +39 0362 805396, Fax: +39 0362 805404
URL: http://www.infotecna.it
