[sqlite] sql query speed problem

hi,guys: I do think sql query speed may not change by just change the join order of 2 tables. But I meet this problem in sqlite just now. so I think something must be wrong in "group by" process in sqlite. In this case: favorite table have more than 1000 records,and t1 table have less than 20

Re: [sqlite] DBD-SQLite build query

--- Darren Duncan <[EMAIL PROTECTED]> wrote: > At 6:20 PM -0700 4/27/05, Clark Christensen wrote: > >Being new to compilers, I have a question about building > >DBD-SQLite (for Perl). If I want to update the > underlying > >SQLite code in DBD-SQLite to the current release, > (v3.2.1), > >i sit

Re: [sqlite] locking and retries in a multi-reader multi-writer environment

Jay writes: > I did this for my writer operations: > > begin immediate; > if busy keep retrying for a reasonable period, if still no lock then error > out. > // lock is now established > // the following should never fail because I have an exclusive lock But you don't have an exclusive lock

Re: [sqlite] locking and retries in a multi-reader multi-writer environment

On 4/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi! SQLite 3.2.1 on win32. > > I'm having trouble wrapping my mind around where I have to be > paranoid about locking issues. In particular, the behavior when > readers and writers overlap, or two writers overlap, is not 100% > clear to

Re: [sqlite] locking and retries in a multi-reader multi-writer environment

On 4/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi! SQLite 3.2.1 on win32. > > I'm having trouble wrapping my mind around where I have to be > paranoid about locking issues. In particular, the behavior when > readers and writers overlap, or two writers overlap, is not 100% > clear to

[sqlite] locking and retries in a multi-reader multi-writer environment

Hi! SQLite 3.2.1 on win32. I'm having trouble wrapping my mind around where I have to be paranoid about locking issues. In particular, the behavior when readers and writers overlap, or two writers overlap, is not 100% clear to me from an obsessive reading and rereading of the locking

[sqlite] memory fault in TCLSQLLite on HPUX 11.11 64 bit creating table

Hello, I am consistantly getting a memory fault in sqlite both through the tclsqlite shared library and the sqlite3 executable when I try to create a table. I have tried both sqlite 3.2.1 and 2.8.16. The TCL Versions tried are 8.4.6 and 8.4.9. I have had success on 32bit HPUX 11.11 but when

Re: [sqlite] determining all tables and fieldnames in a db

On Thu, 28 Apr 2005 [EMAIL PROTECTED] wrote: Try "select * from sqlite-master"; Regards, look good... that combined with 'pragma table_info'... this is o.k. for 2.8.x AND 3.x.x ?? cheers. -a -- === | email :: ara [dot]

Re: [sqlite] Tcl application using sqlite 2.x crashing

On Thu, 2005-04-28 at 11:23 -0500, Dinsmore, Jeff wrote: > Running on Windows Server2003, Tcl 8.4.6, Sqlite 2.x (if I knew how to > determine my exact rev of Sqlite, I'd tell you that too) > There are no known crashing issues with the latest version of SQLite 2.8.16. I do not recall any

Re: [sqlite] Concatenate NULL strings

[EMAIL PROTECTED] wrote: Paolo Vernazza <[EMAIL PROTECTED]> writes: [...] So I tried using coalesce (and ifnull), but it converts the string to a integer... SELECT colasce(a, '') | coalesce(b, '') WHERE ID=1; -> 356 Any idea about howto can I get the proper value? The string

[sqlite] Tcl application using sqlite 2.x crashing

Running on Windows Server2003, Tcl 8.4.6, Sqlite 2.x (if I knew how to determine my exact rev of Sqlite, I'd tell you that too) One wrapped with Tcl apps is (rarely and unrepeatably) blowing up. Multiple instances of this application work fine on thousands of transactions per day, but once every

Re: [sqlite] determining all tables and fieldnames in a db

[28-04-2005 15:14, Ara.T.Howard escreveu] is there a query that can be run against 2.8.x and 3.x dbs that will return something like tablename | fieldname | fieldname | fieldname SELECT tbl_name FROM sqlite_master WHERE type='table'; to get the table list and PRAGMA table_info(tbl_name); to

Re: [sqlite] Concatenate NULL strings

I tried using the | operator, but it seems that concatenating a string and a NULL results in a NULL value.. SELECT a | b FROM test WHERE ID=1; -> NULL The operator for concat is ||, | is for bitwise operation, isn't it? So I tried using coalesce (and ifnull), but it converts the string to a

Re: [sqlite] Concatenate NULL strings

Recreate the test table with a default that sets the column to the empty string ( DEFAULT '' ). If you don't insert a value instead of null you get ''. That will concatenate to give an empty string. On 4/28/05, Paolo Vernazza <[EMAIL PROTECTED]> wrote: > Hi, > I've a table with some data... > >

Re: [sqlite] Concatenate NULL strings

Paolo Vernazza <[EMAIL PROTECTED]> writes: > Hi, > I've a table with some data... > > CREATE table test (ID INTEGER PRIMARY KEY, a TEXT, b TEXT); > INSERT INTO test (id, a, b) VALUES (1, "0356 bla bla bla", NULL); > > I need to retrieve the string resulting from concatenating the a & b >

[sqlite] Concatenate NULL strings

Hi, I've a table with some data... CREATE table test (ID INTEGER PRIMARY KEY, a TEXT, b TEXT); INSERT INTO test (id, a, b) VALUES (1, "0356 bla bla bla", NULL); I need to retrieve the string resulting from concatenating the a & b field... I tried using the | operator, but it seems that

Re: [sqlite] idxchck

On Thu, Apr 28, 2005 at 07:59:02AM +0200, msaka msaka wrote: > how to run idxchck under windows? The Wiki page outlines what is needed: I suggest: 1. Get Tclkit for Windows: http://equi4.com/pub/tk/8.4.9/tclkitsh-win32.upx.exe rename tclkitsh-win32.upx.exe tclkitsh.exe 2. Get

Re: [sqlite] determining all tables and fieldnames in a db

Try "select * from sqlite-master"; Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen Grüßen / Med vänlig hälsning

[sqlite] SQLite under NT 4

Hi, i find that sqlite is very much slower unter WinNT 4.0 than under Win2000 or XP. Does anyone know any special settings (Compiler or at runtime) for NT? Thanks, Martin

Re: [sqlite] determining all tables and fieldnames in a db

> > is there a query that can be run against 2.8.x and 3.x dbs that will return > something like > >tablename | fieldname | fieldname | fieldname > This is a good start at what you want: select name, type, sql from sqlite_master; --- You a Gamer? If you're near Kansas City: Conquest 36

[sqlite] determining all tables and fieldnames in a db

is there a query that can be run against 2.8.x and 3.x dbs that will return something like tablename | fieldname | fieldname | fieldname for example given create table foo ( a, b ); create table bar ( x, y, z ); this should return foo|a|b|NULL bar|x|y|z another

[sqlite] Re: sqlite 3.2.1 lock-2.8 test hangs

On Wed, Apr 27, 2005 at 04:55:00PM -0500, Jolan Luff wrote: > hi, > > when running the sqlite 3.2.1 regression tests, the lock-2.8 test hangs > indefinitely. if i disable that test, all others pass. > > is this a bug in the regression test or is this something i should be > concerned about? >

Re: [sqlite] DBD-SQLite build query

At 6:20 PM -0700 4/27/05, Clark Christensen wrote: Being new to compilers, I have a question about building DBD-SQLite (for Perl). If I want to update the underlying SQLite code in DBD-SQLite to the current release, (v3.2.1), i sit simply a matter of putting the current SQLite sources into the