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 stephanweh...@gmail.com
wrote:
There are some benchmark's at
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
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
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.
On Thu, Jul 28, 2011 at 11:41 AM, Григорий Григоренко grigore...@mail.ruwrote:
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 ).
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
On Thu, Jul 28, 2011 at 9:21 AM, Clifford Hung ch...@rim.com 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 a
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 jerzywitkow...@googlemail.com
Hello,
I tried to upgrade my environment to latest
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
-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 on
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
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
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
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 @ K R E
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, km...@netscape.net wrote:
Is it possible to edit commands entered on the sqlite3 command line?
-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 context
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
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
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
On Thu, Jul 28, 2011 at 12:27 AM, res...@googlemail.com 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 redundant
On Thu, Jul 28, 2011 at 1:08 PM, Jay A. Kreibich j...@kreibi.ch 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
library. In that
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
On Fri, Jul 29, 2011 at 8:53 AM, Richard Hipp d...@sqlite.org wrote:
On Thu, Jul 28, 2011 at 12:27 AM, res...@googlemail.com 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
-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 functions
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 and
-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
-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 SQLite
27 matches
Mail list logo