[sqlite] Doc: wrong xCreate instructions for vtab object

Hi, I think the documentation is wrong in the virtual table document found under http://www.sqlite.org/vtab.html. Under xCreate() it says: "The xCreate method need not initialize the pModule, nRef, and zErrMsg fields of the sqlite3_vtab object." In fact, I

Re: [sqlite] LevelDB benchmark

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 sequential writes per second a

Re: [sqlite] Query with UNION on large table

On Thu, Jun 23, 2011 at 5:59 PM, Simon Slavin wrote: > > On 23 Jun 2011, at 10:56pm, Rense Corten wrote: > > > Simon: no, AFS=Andrew File System :). Both my servers run Ubuntu > > (64-bit). In case of the 12 Gb RAM machine, everything is done > > locally. On the 32 Gb machine, I'm afraid I can't

Re: [sqlite] Dynamically loaded sqlite (linux)

On Tue, Jun 7, 2011 at 12:52 PM, Jay A. Kreibich wrote: > On Tue, Jun 07, 2011 at 07:47:25PM +0400, Max Vlasov scratched on the wall: > > Hi, > > > > I'm trying to use sqlite with linux (Ubuntu, Pascal, Lazarus). I'm still > not > > very familiar with linux development so I might miss something e

Re: [sqlite] Do I need to migrate to MySQL?

On Fri, Jun 3, 2011 at 6:58 AM, Ian Hardingham wrote: > > I may be looking at a complete re-write. I may also need to have a > solution which scales beyond one machine. Can anyone give me advice on > this matter specifically? > > See http://www.sqlite.org/whentouse.html for general usage help.

Re: [sqlite] Python loop over Sqlite database

Try: import sqlite3 conn = sqlite3.connect("database") c = conn.cursor() c.execute('SELECT * FROM table ORDER BY X') for row in c: print row[2] # Where 2 is the X column On Thu, Apr 14, 2011 at 7:06 AM, Johannes Radinger wrote: > Hello, > > I have a table in a sqlite database which looks

Re: [sqlite] Automatic index yields bad performance for a simple join

On Sat, Apr 9, 2011 at 2:49 PM, Richard Hipp wrote: > > > On Sat, Apr 9, 2011 at 8:36 AM, Martin Gadbois wrote: > >> >> If ANALYZE is ran, the speed is fast: there are no auto-index. >> > > There you go. > > Without ANALYZE, the query planner has no ide

Re: [sqlite] Automatic index yields bad performance for a simple join

On Sat, Apr 9, 2011 at 7:06 AM, Richard Hipp wrote: > > > On Fri, Apr 8, 2011 at 10:55 AM, Martin Gadbois wrote: > >> Hi there! >> >> I noticed a heavy slow-down due to automatic indexes. Look at the >> following >> output, where table "event

[sqlite] Automatic index yields bad performance for a simple join

Hi there! I noticed a heavy slow-down due to automatic indexes. Look at the following output, where table "events" has 100k entries, and "tags" has ~10 entries: SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .stats on sqlite> .timer on sqlit