Re: [sqlite] ANN: SQLite 3.6.16.C#

On 1 Aug 2009, at 11:07pm, Fred Williams wrote: > SQLite was and has always been designed to be extremely cross platform > portable, bare bones in both footprint and implementation. It is, and > should remain so. If someone wants to take the open source and > implement it > in something like

Re: [sqlite] ANN: SQLite 3.6.16.C#

No I'm not proud of what a lot of OS providers produce. Microsoft in particular. Sun's Java is becoming such a resource pig, I won't mess with it either. SQLite was and has always been designed to be extremely cross platform portable, bare bones in both footprint and implementation. It is, and

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Sat, Aug 1, 2009 at 1:05 PM, Jim Showalter wrote: > I don't know the background of why this programmer did a port directly > to C# instead of binding C# to the existing C library, but I assume he > had his reasons. He says very clearly on the code website, he did so to

Re: [sqlite] ANN: SQLite 3.6.16.C#

Could we not disparage different OSs and languages? A fair comparison of performance isn't between a C and C# implementation of SQLite, but between a C# and Java implementation of SQLite. Both C# and Java are managed languages that run atop a VM that runs atop an OS. C is down on the metal. I

Re: [sqlite] ANN: SQLite 3.6.16.C#

This is not a driver, dll, or wrapper. This is a port of the underlying SQLite software. Noah Yves Goergen wrote: > > On 01.08.2009 02:14 CE(S)T, Noah Hart wrote: >> I am pleased to announce that the C# port is done to the point where >> others >> can look at it. >> >> The project is located

Re: [sqlite] ANN: SQLite 3.6.16.C#

Max, I missed posting the remaining errors Current results ... 9 errors out of 30054 tests Still skipping about 9 additional tests Noah Kosenko Max wrote: > > Wow, that's impressive. > > And very interesting that you've gained 3x-5x performance gain. > Don't make this project educational

Re: [sqlite] ANN: SQLite 3.6.16.C#

The compiled version of the SQLite3.exe is 528KB vs 506KB for the official release I haven't checked the footprint while it is running. That would be depend on what it is doing ... Noah Fred Williams wrote: > > > Hummm... Guess there is a reason there are no implementations of C# > external

Re: [sqlite] ANN: SQLite 3.6.16.C#

Yes, but still decent speed All Results are in Rows per Second TestSQLite3C# SQLite3 Inserts 300K1300K Selects 1500K 8450K Updates 60K 300K Deletes 250K700K Noah Kosenko Max wrote: > > Seems like I've misunderstood your performance results. And they are > 3-5times

Re: [sqlite] ANN: SQLite 3.6.16.C#

Cory, There was no attempt at optimization in this initial port. SQLite does a lot of char/byte/string manipulation as well as and passing parameters by address in the middle of an array. But I ended up having to do a lot of byte buffer copying. MY guess is that is where most of the time is

Re: [sqlite] ANN: SQLite 3.6.16.C#

On 01.08.2009 02:14 CE(S)T, Noah Hart wrote: > I am pleased to announce that the C# port is done to the point where others > can look at it. > > The project is located at http://code.google.com/p/sqlitecs Excuse me, but what's the difference of this to SQLite ADO.NET at

Re: [sqlite] ANN: SQLite 3.6.16.C#

Fred Williams wrote: > Hummm... Guess there is a reason there are no implementations of C# > external to the Mickeysoft world :-) One of the reason is true multiplatform support with Mono for managed world. Another one is Silverlight DB. - Best Regards. Max Kosenko. -- View this

Re: [sqlite] ANN: SQLite 3.6.16.C#

Only 10 DllImport (files and performance), most can be moved to managed version. goto isn't something slow with C# - so it can't be a bottleneck. But it would be interesting to study this with profiler and see what is the real reason. I believe it shouldn't be that different in performance.

Re: [sqlite] ANN: SQLite 3.6.16.C#

Hummm... Guess there is a reason there are no implementations of C# external to the Mickeysoft world :-) Guess if I had a lot of time to kill I could port it to Delphi... BTW, what's the memory footprint? Fred -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Sat, Aug 1, 2009 at 4:21 AM, Kosenko Max wrote: > > Seems like I've misunderstood your performance results. And they are 3-5times > slower than original... > This could be for a number of reasons. For one, it uses p/invoke for a number of things, which can be pretty slow

Re: [sqlite] ANN: SQLite 3.6.16.C#

Seems like I've misunderstood your performance results. And they are 3-5times slower than original... - Best Regards. Max Kosenko. -- View this message in context: http://www.nabble.com/ANN%3A--SQLite-3.6.16.C--tp24764742p24768252.html Sent from the SQLite mailing list archive at

Re: [sqlite] ANN: SQLite 3.6.16.C#

Wow, that's impressive. And very interesting that you've gained 3x-5x performance gain. Don't make this project educational only. I'm sure you'll find additional contributors. Just recently Miguel de Icaza was asking for line by line port of SQLite to C#. Great achievement that all tests are