Re: [sqlite] LevelDB benchmark

2011-07-27 Thread Stephan Wehner
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

Re: [sqlite] LevelDB benchmark

2011-07-27 Thread Martin Gadbois
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

Re: [sqlite] LevelDB benchmark

2011-07-27 Thread Simon Slavin
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

Re: [sqlite] LevelDB benchmark

2011-07-27 Thread David Garfield
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

Re: [sqlite] LevelDB benchmark

2011-07-27 Thread Simon Slavin
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

Re: [sqlite] LevelDB benchmark

2011-07-27 Thread Stephan Wehner
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

Re: [sqlite] LevelDB benchmark

2011-07-27 Thread J Decker
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

Re: [sqlite] LevelDB benchmark

2011-07-27 Thread Simon Slavin
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

[sqlite] LevelDB benchmark

2011-07-27 Thread Stephan Wehner
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

Re: [sqlite] SQLITE_OMIT_UTF16

2011-07-27 Thread Roger Binns
-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

Re: [sqlite] Strange result using JOIN

2011-07-27 Thread Sintoni Stefano (GMAIL)
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

[sqlite] sqlite3_soft_heap_limit affecting results? (debugging help request)

2011-07-27 Thread Jan Hudec
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

Re: [sqlite] SELECT query first run is VERY slow

2011-07-27 Thread Jay A. Kreibich
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); >

Re: [sqlite] c-api

2011-07-27 Thread John Deal
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"

Re: [sqlite] c-api

2011-07-27 Thread Doug Currie
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

Re: [sqlite] c-api

2011-07-27 Thread Igor Tandetnik
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

[sqlite] c-api

2011-07-27 Thread Baruch Burstein
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

Re: [sqlite] SQLITE_OMIT_UTF16

2011-07-27 Thread Baruch Burstein
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 ? >

Re: [sqlite] SQLITE_OMIT_UTF16

2011-07-27 Thread Simon Slavin
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

[sqlite] SQLITE_OMIT_UTF16

2011-07-27 Thread Baruch Burstein
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

Re: [sqlite] trying to build from sqlite-3.6.7 on ubuntu 11.04, missing sqlite3.c

2011-07-27 Thread Robert P. J. Day
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

[sqlite] Large DB files fragmentation

2011-07-27 Thread LiranR
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