On Sat, Aug 29, 2009 at 9:51 PM, Yves
Goergen 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
>
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
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
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
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:
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
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.
--
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
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 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
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,
P Kishor wrote:
> On Sun, Aug 2, 2009 at 7:57 AM, Noah Hart 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
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
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
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.
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
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
forums/t/1642.aspx
>
> - Original 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.1
quot; <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 questio
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:
>
>
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
> -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
Sunday, August 02, 2009 11:23 AM
Subject: Re: [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,
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:
>
arketed."
Fred
-Original 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 remind
[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
On Sun, Aug 2, 2009 at 7:57 AM, Noah Hart 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
What about SqlSharp?
Tim
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Noah Hart
> Sent: 02 August 2009 13:58
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
>
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
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
Original Message -
> From: "Fred Williams" <f.willi...@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#
>
* 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
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
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 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
gt;
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 :-)
>
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
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
..@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 origin
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
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
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
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
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.
-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
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
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
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
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
49 matches
Mail list logo