Re: [sqlite] Newbie sql: query and joining more than two tables

Thanks for your suggestions! On Monday 06 June 2005 05.22, Ulrik Petersen wrote: > Hi Karim, > > Cláudio Leopoldino wrote: > > You may use EXPLAIN clause and verify the reazon... > > > > Cláudio > > > >> Hi! > >> > >> I hope to get some feedback whether the query time is what I should > >> expect.

[sqlite] Newbie sql: query and joining more than two tables

Hi! I hope to get some feedback whether the query time is what I should expect. Running this query below takes several seconds - typically 1-3s. SELECT package.id, package.name, package.description, package.size, package.latest, version.version FROMcategory, package, versio

Re: [sqlite] Assertion failed in btree.c:1219

Thanks for the suggestion ... I found what's missing in configure.in.in: KDE_CHECK_TYPES AC_DEFINE(SQLITE_PTR_SZ, SIZEOF_CHAR_P, [Determine pointer size for SQLite Now it's working :-) On Wednesday 01 June 2005 16.45, D. Richard Hipp wrote: > On Wed, 2005-06-01 at 15:27 +0200, Kar

[sqlite] Assertion failed in btree.c:1219

Hi! Can someone tell me why I get this error? Commenting out this line in "sqlite3BtreeOpen" and the app starts ok: ... assert( sizeof(ptr)==sizeof(char*) ); ... Cheers! /Karim

[sqlite] Updating tables in threaded app: a few question

Hi! I have a table with 19000 rows which needs to updated and accessed by different threads. One approach to avoid locking the table as much is to create a TABLE TEMP mytable and as last action in threads to move rows from mytable_tmp to mytable, like this: BEGIN TRANSACTION; CREATE TEMP TABL