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
> engine? I mean, there's no cli
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
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 TEST
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 TEST
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:
http://www.nabble
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(
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, but
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 not. SQLite is a regist
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 r
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. won
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
here
forums/t/1642.aspx
>
> - Original Message - From: "Konrad J Hambrick"
> To: "General Discussion of SQLite Database"
> Sent: Sunday, August 02, 2009 12:19 PM
> Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
>
>
>>
>> Noah --
>>
>> This i
"
To: "General Discussion of SQLite Database"
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
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 w
> -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 insist
t may have been true initially, and may still be true for
specialized cases (video drivers?), but in general it's poppycock.
- Original Message -
From: "Fred Williams"
To: "General Discussion of SQLite Database"
Sent: Sunday, August 02, 2009 11:23 AM
Subject: Re:
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
sqlite.org
[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 th
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 registered trade mark. If
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 (especial
> had his reasons.
>
> - Original Message -
> From: "Fred Williams"
> To: "General Discussion of SQLite Database"
> Sent: Saturday, August 01, 2009 6:08 AM
> Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
>
>
>>
>> Hummm... Guess
* 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
ht
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
g, and every thing in its 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
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 learn C#. As I
wrote in m
ussion of SQLite Database"
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
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 on
sers-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
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 slo
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 spe
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
http://sqlite.phxsoftware.
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 messag
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.
Cory
qlite-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.
M
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 and is not portable.
A
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 Nabble.co
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 pas
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 SQLit
49 matches
Mail list logo