On Sat, Aug 29, 2009 at 9:51 PM, Yves
Goergennospam.l...@unclassified.de wrote:
On 01.08.2009 16:19 CE(S)T, Noah Hart wrote:
This is not a driver, dll, or wrapper. This is a port of the underlying
SQLite software.
Hm, yes, but isn't the other C# SQLite assembly also the entire DB
engine? I
On 01.08.2009 16:19 CE(S)T, Noah Hart wrote:
This is not a driver, dll, or wrapper. This is a port of the underlying
SQLite software.
Hm, yes, but isn't the other C# SQLite assembly also the entire DB
engine? I mean, there's no client/server driver; if you can access
SQLite files, you already
On Aug 2, 2009, at 6:25 PM, Kosenko Max wrote:
9/30054 means 99.97% tests are working.
That's a great achievement anyway.
Performance problems can be profiled and optimized simpler than with
native
version.
That isn't a nature of managed code to be slow. i.e. Perst DB which is
managed
Dan Kennedy-4 wrote:
McObject CEO Steve Graves points out that because of limits of the API
they were using, SQLite performs each INSERT and DELETE in the test in a
separate transaction. So the reported times for these tests may be more of
a measure of the speed of the media than SQLite
On Aug 3, 2009, at 2:06 PM, Kosenko Max wrote:
Dan Kennedy-4 wrote:
McObject CEO Steve Graves points out that because of limits of the
API
they were using, SQLite performs each INSERT and DELETE in the test
in a
separate transaction. So the reported times for these tests may be
Dan Kennedy-4 wrote:
Are you by any chance the author of the report I'm reading?
I'm not an author of test or McObject staff/representative at all. But I can
give a link to this forum to author (still insisting that this is offtopic
here) to answer himself.
-
Best Regards.
Max Kosenko.
--
Dan Kennedy-4 wrote:
Earlier I just quoted the conclusions of the McObject report. Maybe I
misunderstood. But now that I have read the benchmark code, I'm curious.
Why is the SQL not being recompiled for each query? Is there some kind of
compiled query cache hiding behind the [db.query()]
Sorry, test bug in SQLite select test.
http://www.nabble.com/file/p24789308/TestIndex.cs TestIndex.cs
index searches:
20: SQLITE 8.1635400 PERST 3.3406065
200: SQLITE 1:10.6331745 PERST 54.9915975
-
Best Regards.
Max Kosenko.
--
View this message in context:
I need to apologize once again. Slow deletes explained as bug in SQLite tests
and flags of Perst compilation. Now they both head to head on basic ops with
2x on Perst selects (can be due to the ADO reader instantiations)
http://www.nabble.com/file/p24795731/TestIndex.cs TestIndex.cs
SQLITE
I need to apologize once again. Slow deletes explained as bug in SQLite tests
and flags of Perst compilation. Now they both head to head on basic ops with
2x on Perst selects (can be due to the ADO reader instantiations)
http://www.nabble.com/file/p24795746/TestIndex.cs TestIndex.cs
SQLITE
* Noah Hart:
I am pleased to announce that the C# port is done to the point where others
can look at it.
Congratulations!
(Is there something similar for Java, not using JNI nor NestedVM? 8-)
___
sqlite-users mailing list
sqlite-users@sqlite.org
...@verizon.net
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Saturday, August 01, 2009 6:08 AM
Subject: 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
9/30054 means 99.97% tests are working.
That's a great achievement anyway.
Performance problems can be profiled and optimized simpler than with native
version.
That isn't a nature of managed code to be slow. i.e. Perst DB which is
managed from scratch is same speed or faster than SQLite
Richard sent me a gentle reminder that read in part:
Please also note that the SQLite source code is in the public domain, but
the SQLite name is not. SQLite is a registered trade mark. If I don't
defend the trademark, then I could lose it. So, I
On Sun, Aug 2, 2009 at 7:57 AM, Noah Hartn...@lipmantpa.com wrote:
Richard sent me a gentle reminder that read in part:
Please also note that the SQLite source code is in the public domain, but
the SQLite name is not. SQLite is a registered trade
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Kosenko Max
Sent: Sunday, August 02, 2009 6:32 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
I don't know why you have decided that C# or Java isn't competitive to
native
compiled code.
After JIT there is no VM between
Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Noah Hart
Sent: Sunday, August 02, 2009 7:58 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
Richard sent me a gentle reminder that read in part
It's a pity news. I hoped Dr. can think about even somehow supporting your
project.
I don't know why he insists on that (he actually can answer for himself
here) while there are a lot of SQLite based projects with that name usage.
May be that's because of your license?
Max.
Noah Hart wrote:
: [sqlite] ANN: SQLite 3.6.16.C#
I have at least a screwdriver and monkey wrench to go with my hammer
in my
computer software tool bag. Observing the fastener at hand allows
me to
pick the proper tool. Then if that doesn't work, there's always the
hammer.
-Original Message-
From
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Kosenko Max
Sent: 02 August 2009 19:40
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
I don't know why he insists on that (he actually can answer
Seems like I've missed something...
Well, if there would be a team dedicated to supporting managed
implementation of SQLite which can be at any time quickly updated to reflect
all changes of SQLite native - anyone can always transfer such requests to
that team. Same happens i.e. with SQLite.NET
Noah --
This is a wonderful accomplishment !
However, I have a question ...
Doesn't C# support native function calls ?
If so, other than scratching an itch, what does a native port to C# do ?
Thanks.
-- kjh
Noah Hart wrote:
Richard sent me a gentle reminder that read in part:
...@payplus.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Sunday, August 02, 2009 12:19 PM
Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
Noah --
This is a wonderful accomplishment !
However, I have a question ...
Doesn't C# support native function calls ?
If so, other
Message - From: Konrad J Hambrick kon...@payplus.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Sunday, August 02, 2009 12:19 PM
Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
Noah --
This is a wonderful accomplishment !
However, I have a question
The license is the same as SQLite, I'm waiting on google to change the
project to PD since that is not one of the canned choices.
Noah
It's a pity news. I hoped Dr. can think about even somehow supporting your
project.
I don't know why he insists on that (he actually can answer for himself
And in the Window's there are ...
For example:
System.Data.SQLite
An open source ADO.NET provider for the SQLite database engine
http://sqlite.phxsoftware.com/
http://code.google.com/p/sqlite-ng/
sqlite-ng A fork of SQLite with more community involvement
SQLite-ng is a fork of SQLite with the
Noah Hart wrote:
The license is the same as SQLite, I'm waiting on google to change the
project to PD since that is not one of the canned choices.
Thank you very much.
Can't disagree with Miguel that this is A godsend gift to developers.
Keep us informed about name change (in case Dr. won't
Maybe the author could explain the reason for C# translation. Surely a
better approach if the JIT is required would be to use something like
gcc and change the code generator to the C# metacode. Such a product
may already exist.
A translated program is rev locked.
Kosenko Max wrote:
Seems
John Stanton-3 wrote:
Maybe the author could explain the reason for C# translation. Surely a
better approach if the JIT is required would be to use something like
gcc and change the code generator to the C# metacode. Such a product
may already exist.
A translated program is rev
P Kishor wrote:
On Sun, Aug 2, 2009 at 7:57 AM, Noah Hartn...@lipmantpa.com wrote:
Richard sent me a gentle reminder that read in part:
Please also note that the SQLite source code is in the public domain, but
the SQLite name is not. SQLite is a
Hi Noah,
A name suggestion:
SharpLightSQL - SLSQL or just SLS.
Sunday, August 2, 2009, 10:57:56 PM, you wrote:
NH Richard sent me a gentle reminder that read in part:
NH
NH Please also note that the SQLite source code is in the public domain, but
NH
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
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
On Sat, Aug 1, 2009 at 4:21 AM, Kosenko Maxkosenko@vyzo.com 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 and
-users-boun...@sqlite.org]on Behalf Of Kosenko Max
Sent: Saturday, August 01, 2009 6:22 AM
To: sqlite-users@sqlite.org
Subject: 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
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.
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 message
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
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
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
01, 2009 6:22 AM
To: sqlite-users@sqlite.org
Subject: 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
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 at
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 only.
of SQLite Database sqlite-users@sqlite.org
Sent: Saturday, August 01, 2009 6:08 AM
Subject: 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
On Sat, Aug 1, 2009 at 1:05 PM, Jim Showalterj...@jimandlisa.com 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 learn
place, so to speak.
Fred
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Jim Showalter
Sent: Saturday, August 01, 2009 1:06 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
Could we
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 C#
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
Enjoy,
Noah Hart
--
View this message in context:
http://www.nabble.com/ANN%3A--SQLite-3.6.16.C--tp24764742p24764742.html
Sent from the
48 matches
Mail list logo