RE: [sqlite] SQLite.Net

2007-09-19 Thread Michael Martin
. Adapting the sqlite3 api to .NET is not trivial. > -Original Message- > From: Michael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 8:09 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQLite.Net > > I am using this http://www.php

RE: [sqlite] SQLite.Net

2007-09-19 Thread Michael Martin
t 3 years so it probably has issues as well. Your best bet is to use the ADO.NET 2.0 provider at http://sqlite.phxsoftware.com Robert > -Original Message- > From: Michael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 7:42 AM > To: sqlite-user

RE: [sqlite] SQLite.Net

2007-09-19 Thread Michael Martin
SQLite.NET.2.0.1 -Message d'origine- De : Robert Simpson [mailto:[EMAIL PROTECTED] Envoyé : mercredi 19 septembre 2007 16:31 À : sqlite-users@sqlite.org Objet : RE: [sqlite] SQLite.Net What .NET wrapper are you using? > -Original Message- > From: Michael Martin [ma

[sqlite] SQLite.Net

2007-09-19 Thread Michael Martin
Hi all, I try to use SQLite (sqlite3.dll) in DotNet; this is my code : SQLiteClient db= new SQLiteClient("test.db"); SQLiteResultSet results; results = db.Execute("create table Table1(one int primary key, two varchar(10));"); results = db.

RE: [sqlite] SQLite or MS Access

2007-09-07 Thread Michael Martin
tions not multiuser. Ive done Inserts up to the 40-50K/ sec in sqlite with the right kind of tweaks. -Original Message- From: Michael Martin [mailto:[EMAIL PROTECTED] Sent: 07 September 2007 10:06 AM To: sqlite-users@sqlite.org Subject: [sqlite] SQLite or MS Access Hi All, I'

[sqlite] SQLite or MS Access

2007-09-07 Thread Michael Martin
Hi All, I've done some benchmarks tests and I wonder where I've made a mistake. In C# code with SQLite.NET.2.0.1 wrapper with sqlite 3.0: 1000 inserts in a table of two columns -> 168 seconds In C# code with Jet.Oledb.4.0 with MS Access: 1000 inserts in a table of two columns -> 1.14