On Wed, Jul 27, 2011 at 7:00 PM, Simon Slavin wrote:
>
> On 28 Jul 2011, at 2:53am, Stephan Wehner wrote:
>
>> On Wed, Jul 27, 2011 at 6:44 PM, Simon Slavin wrote:
>>>
>>> On 28 Jul 2011, at 2:22am, Stephan Wehner wrote:
>>>
There are some
On Wed, Jul 27, 2011 at 9:22 PM, Stephan Wehner wrote:
> There are some benchmark's at
> http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html
>
> I don't have anything to point to, but I thought sqlite3 does better
> than stated there.
>
> In particular, 26,900
On 28 Jul 2011, at 3:01am, David Garfield wrote:
> They used REPLACE. See
> http://code.google.com/p/leveldb/source/browse/trunk/doc/bench/db_bench_sqlite3.cc#492
>
> They used explicit transactions, and tested with both single REPLACE
> transactions and 1000 REPLACE transactions. Section 1A
They used REPLACE. See
http://code.google.com/p/leveldb/source/browse/trunk/doc/bench/db_bench_sqlite3.cc#492
They used explicit transactions, and tested with both single REPLACE
transactions and 1000 REPLACE transactions. Section 1A would be the
single REPLACE transactions, while 2B is the
On 28 Jul 2011, at 2:53am, Stephan Wehner wrote:
> On Wed, Jul 27, 2011 at 6:44 PM, Simon Slavin wrote:
>>
>> On 28 Jul 2011, at 2:22am, Stephan Wehner wrote:
>>
>>> There are some benchmark's at
>>> http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html
>>>
>>> I
On Wed, Jul 27, 2011 at 6:44 PM, Simon Slavin wrote:
>
> On 28 Jul 2011, at 2:22am, Stephan Wehner wrote:
>
>> There are some benchmark's at
>> http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html
>>
>> I don't have anything to point to, but I thought sqlite3 does
On Wed, Jul 27, 2011 at 6:22 PM, Stephan Wehner wrote:
> There are some benchmark's at
> http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html
>
> I don't have anything to point to, but I thought sqlite3 does better
> than stated there.
>
> In particular, 26,900
On 28 Jul 2011, at 2:22am, Stephan Wehner wrote:
> There are some benchmark's at
> http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html
>
> I don't have anything to point to, but I thought sqlite3 does better
> than stated there.
i looked through their source code, trying to see if
There are some benchmark's at
http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html
I don't have anything to point to, but I thought sqlite3 does better
than stated there.
In particular, 26,900 sequential writes per second and 420 random writes
per second from section "1. Baseline
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/27/2011 04:16 AM, Baruch Burstein wrote:
> The thing I don't understand is how can this be, because when I search
> sqlite3.c for "SQLITE_OMIT_UTF16", I am told it doesn't exist in this file!
You need a better search tool. Against the 3.7.7.1
Many thanks to all those who have given me great tips.
*Sintoni Stefano*
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello,
At $work we have an Android application that uses sqlite3 (compiled from
amalgamation version 3.7.6.3 with a little tweak to get fdatasync() defined).
In the application we set soft heap limit. Now today we noticed that
something fails when the heap limit is 2MiB, but works fine when we
On Tue, Jul 26, 2011 at 05:13:00PM +, Black, Michael (IS) scratched on the
wall:
> Part of the problem is it seems you can't create an index with rowid:
>
>
>
> 3.7.5
>
> sqlite> create table t(i int);
> sqlite> create index idx1 on t(i);
> sqlite> create index idx2 on t(i,rowid);
>
Hello Baruch,
You may want to look at sqlite3_exec() (http://www.sqlite.org/c3ref/exec.html).
John
--- On Wed, 7/27/11, Baruch Burstein wrote:
> From: Baruch Burstein
> Subject: [sqlite] c-api
> To: "General Discussion of SQLite Database"
On Jul 27, 2011, at 9:22 AM, Baruch Burstein wrote:
> Is there an easier way to get a single value (for instance "select
> last_insert_rowid();" ) then prepare -> step -> column -> finalize?
http://www.sqlite.org/capi3ref.html#sqlite3_last_insert_rowid
e
Baruch Burstein wrote:
> Is there an easier way to get a single value (for instance "select
> last_insert_rowid();" ) then prepare -> step -> column -> finalize?
For this specific example, there's sqlite3_last_insert_rowid API function.
In general, no, there's no special
Is there an easier way to get a single value (for instance "select
last_insert_rowid();" ) then prepare -> step -> column -> finalize?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
It is a typo in the mail. originally it is a '.'
On Wed, Jul 27, 2011 at 2:53 PM, Simon Slavin wrote:
>
> On 27 Jul 2011, at 12:16pm, Baruch Burstein wrote:
>
> > when I use
> >
> >> gcc -Os -c -DSQLITE_OMIT_UTF16 sqlite3,c
>
> Is that a comma or stop in the original ?
>
On 27 Jul 2011, at 12:16pm, Baruch Burstein wrote:
> when I use
>
>> gcc -Os -c -DSQLITE_OMIT_UTF16 sqlite3,c
Is that a comma or stop in the original ?
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
When I compile the amalgamation with
> gcc -Os -c sqlite3.c
I get a 415 KB sqlite3.o. But when I use
> gcc -Os -c -DSQLITE_OMIT_UTF16 sqlite3,c
I get a 409 KB file.
The thing I don't understand is how can this be, because when I search
sqlite3.c for "SQLITE_OMIT_UTF16", I am told it doesn't
On Tue, 26 Jul 2011, Pavel Ivanov wrote:
> > as part of an embedded system build, i'm building a number of
> > tools for the *host* system, including sqlite-3.6.7 from the
> > tarball (along with a few patches which i will be examining
> > shortly).
>
> Apparently you are building from canonical
Hello!
I want to build a big DB file (about 16 GB).
now, The DB will be updated all the time, row by row.
I know that SQLIte will automatic define the value of the cell by it's
value size.
I think that this can cause that when the cell is updated from 8 bytes to 4
bytes (or vice versa ) , it
22 matches
Mail list logo