Re: [sqlite] LevelDB benchmark

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2011 07:39 PM, Simon Slavin wrote: > Actually I don't see how BLOBs can be used in an index anyway, since > technically blobs have no ordering. memcmp provides an ordering just as it can for strings without a collation. (That is what

Re: [sqlite] Anyone have sqlite shared library for AIX 64 bit?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2011 03:05 PM, Dale Arntson wrote: > I installed python 2.7.1 for AIX 6.1 (64 bit), but it appears to be > missing the _sqlite3.so library, even though this is a standard library > that comes with the current python release on all other

Re: [sqlite] LevelDB benchmark

On 29 Jul 2011, at 3:34am, Roger Binns wrote: > On 07/28/2011 06:57 PM, Simon Slavin wrote: >> Would it improve the SQLite time if it was changed to strings instead of >> BLOBs ? > > Note that internally SQLite treats strings and blobs virtually identically. > Usually the same data structure

Re: [sqlite] LevelDB benchmark

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2011 06:57 PM, Simon Slavin wrote: > Would it improve the SQLite time if it was changed to strings instead of > BLOBs ? Note that internally SQLite treats strings and blobs virtually identically. Usually the same data structure and

Re: [sqlite] LevelDB benchmark

On Fri, Jul 29, 2011 at 8:53 AM, Richard Hipp wrote: > On Thu, Jul 28, 2011 at 12:27 AM, wrote: > > > they used > > > > CREATE TABLE test (key blob, value blob, PRIMARY KEY(key)) > > CREATE INDEX keyindex ON test (key) > > > > Notice the inefficiencies

Re: [sqlite] LevelDB benchmark

There are the LevelDB sources and tests svn checkout http://leveldb.googlecode.com/svn/trunk/ leveldb-read-only Build SQLite test as make db_bench_sqlite3 And LevelDB test as make db_bench My patch for leveldb-read-only/doc/bench/db_bench_sqlite3.cc to disable redudant index and enable WAL is

Re: [sqlite] Editing sqlite3 commands

On Thu, Jul 28, 2011 at 1:08 PM, Jay A. Kreibich wrote: > On Thu, Jul 28, 2011 at 12:57:45PM -0700, km4hr scratched on the wall: >> >> Is there a way to edit SQL commands typed in on the command line? > >  Only if the "sqlite3" tool is compiled with a copy of the readline >  

Re: [sqlite] LevelDB benchmark

On Thu, Jul 28, 2011 at 12:27 AM, wrote: > they used > > CREATE TABLE test (key blob, value blob, PRIMARY KEY(key)) > CREATE INDEX keyindex ON test (key) > Notice the inefficiencies inherent in this schema. (1) A primary key on a BLOB? Really? (2) They create an

Re: [sqlite] LevelDB benchmark

Hm, I test I find index on PK field: CREATE TABLE test (key blob, value blob, PRIMARY KEY(key)) CREATE INDEX keyindex ON test (key) Epic fail, I think :D Default test on Intel(R) Atom(TM) CPU N450 @ 1.66GHz fillseq : 442.937 micros/op;0.2 MB/s fillseqsync :1678.168

Re: [sqlite] LevelDB benchmark

LevelDB use append log but SQLite is tested without WAL :) I check and some tests 2.5x faster with WAL. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Anyone have sqlite shared library for AIX 64 bit?

I installed python 2.7.1 for AIX 6.1 (64 bit), but it appears to be missing the _sqlite3.so library, even though this is a standard library that comes with the current python release on all other platforms. Does anyone know of the existence of a sqlite3 shared library for AIX 6.1 (64 bit) or

Re: [sqlite] Getting a handle to open blobs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2011 09:21 AM, Clifford Hung wrote: > For statements, sqlite3_next_stmt() can be called to return a pointer to the > first prepared statement associated with a database connection In my opinion that API is a huge mistake outside the

Re: [sqlite] Editing SQL commands in sqlite3

If you configure and compile sqlite3 command line yourself and your system have readline installed then yes. Pavel On Thu, Jul 28, 2011 at 4:08 PM, wrote: > Is it possible to edit commands entered on the sqlite3 command line? > > > > > >

Re: [sqlite] Editing sqlite3 commands

On Thu, Jul 28, 2011 at 12:57:45PM -0700, km4hr scratched on the wall: > > Is there a way to edit SQL commands typed in on the command line? Only if the "sqlite3" tool is compiled with a copy of the readline library. In that case, just hit up-arrow. -j -- Jay A. Kreibich < J A Y @

[sqlite] Editing SQL commands in sqlite3

Is it possible to edit commands entered on the sqlite3 command line? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Editing sqlite3 commands

Is there a way to edit SQL commands typed in on the command line? -- View this message in context: http://old.nabble.com/Editing-sqlite3-commands-tp32158636p32158636.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users

[sqlite] Loading Data

hey all. i got my engine to compile so now im doing basic SQL syntax of load the user, since its in a very early production stage the players table only has 4 values to load. Table: Players UserID varchar(30) /* their constant userid */ Race smallint /* their

Re: [sqlite] SQLITE_OMIT_UTF16

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2011 12:40 AM, Baruch Burstein wrote: > On the same topic, I know the documentation says SQLITE_OMIT_* are not > supported by the amalgamation, but I have used many of them to successfully > reduce my object file. Is there any documentation

[sqlite] Cannot load DLLs using NUnit with SQLite

Hello, My situation is that I am setting up our testing project for unit tests using NUnit. The requirements are developers must be able to run the tests from within visual studio and through the nunit exe, and also our continuous integration server must be able to run the unit tests after a

Re: [sqlite] Cannot find tclsqlite3.dll in latest binary distribution for Windows

The tclsqlite3.dll i do not know. But this days i've used the ActiveTcl http://www.activestate.com/activetcl the instalation of him installs the tcl85.dll I think it maybe can help you. 2011/7/27 Jerzy Witkowski > Hello, > > I tried to upgrade my environment to

Re: [sqlite] Getting a handle to open blobs

On Thu, Jul 28, 2011 at 9:21 AM, Clifford Hung wrote: > I would like to make a feature request for a function to return a handle to > the first open blob handle. For statements, sqlite3_next_stmt() can be > called to return a pointer to the first prepared statement associated with

[sqlite] Getting a handle to open blobs

I would like to make a feature request for a function to return a handle to the first open blob handle. For statements, sqlite3_next_stmt() can be called to return a pointer to the first prepared statement associated with a database connection but there doesn't appear to be such a function for

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

On Thu, Jul 28, 2011 at 11:41 AM, Григорий Григоренко wrote: > So, should we file this as a defect or bug somehow? > > As I understand currently the issues acknowledged and fixed during the e-mail conversation in this list ( read http://www.sqlite.org/src/wiki?name=Bug+Reports

[sqlite] Cannot find tclsqlite3.dll in latest binary distribution for Windows

Hello, I tried to upgrade my environment to latest Sqlite distribution 3.7.7.1. Usually I downloaded two files from Download page http://www.sqlite.org/download.html section "Precompiled Binaries For Windows": sqlite3.exe and tclsqlite3.dll. This time I was unable to find tclsqlite3.dll file.

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

So, should we file this as a defect or bug somehow? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_OMIT_UTF16

Thank you. I went back through my command history and saw I had accidentally searched sqlite3.h instead of sqlite3.c Sorry to bother everyone. On the same topic, I know the documentation says SQLITE_OMIT_* are not supported by the amalgamation, but I have used many of them to successfully reduce

Re: [sqlite] LevelDB benchmark

they used CREATE TABLE test (key blob, value blob, PRIMARY KEY(key)) CREATE INDEX keyindex ON test (key) on random replaces it doubles the write operations. J Decker schrieb: > On Wed, Jul 27, 2011 at 6:22 PM, Stephan Wehner > wrote: >> There are some benchmark's