Re: [sqlite] Slow SQL statements

2005-05-22 Thread D. Richard Hipp
On Sun, 2005-05-22 at 19:42 -0400, Al Danial wrote: > then try queries such as > > sqlite baseball.db 'select playerid,sb from batting where sb = (select > max(sb) from batting where playerid in (select playerid from fielding > where pos = "3B" and lgid = "NL"));' > > which tries to answer the

Re: [sqlite] How to lock my database?

2005-05-22 Thread Cory Nelson
http://www.sqlite.org/lang_transaction.html On 5/22/05, liigo <[EMAIL PROTECTED]> wrote: > How to lock my database? > > Thanks for help! > > -- Cory Nelson http://www.int64.org

[sqlite] Transaction for single SQL query?

2005-05-22 Thread Brown, Dave
Is there any benefit in a C program to wrapping a single insert via sqlite3_exec() in a transaction? In other words, is INSERT INTO table1 VALUES(1,2); any worse (or better) than doing: BEGIN; INSERT INTO table1 VALUES(1,2); COMMIT; Thanks, Dave

[sqlite] How to lock my database?

2005-05-22 Thread liigo
How to lock my database? Thanks for help!

Re: [sqlite] Behavior on corrupt database

2005-05-22 Thread D. Richard Hipp
On Sun, 2005-05-22 at 21:12 +0200, Ludvig Strigeus wrote: > If I corrupt my database in certain ways, I can make Sqlite crash. Is > this by design, or is it a bug? > This is a bug, though not a high-priority one. -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Behavior on corrupt database

2005-05-22 Thread Ludvig Strigeus
If I corrupt my database in certain ways, I can make Sqlite crash. Is this by design, or is it a bug? /Ludvig

Re: [sqlite] unit tests

2005-05-22 Thread D. Richard Hipp
On Sun, 2005-05-22 at 20:35 +0200, Ludvig Strigeus wrote: > How do I run the unit tests in Linux? > > I've managed to build "tclsqlite3", but where do I go from there? > make testfixture ./testfixture ../sqlite/test/all.test Or simply make fulltest -- D. Richard Hipp <[EMAIL

Re: [sqlite] unit tests

2005-05-22 Thread G. Roderick Singleton
On Sun, 2005-05-22 at 14:01 -0500, Kurt Welgehausen wrote: > > How do I run the unit tests in Linux? > > make test Running make test as root can give odd results. Use a user account. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech

Re: [sqlite] unit tests

2005-05-22 Thread Kurt Welgehausen
> How do I run the unit tests in Linux? make test

[sqlite] unit tests

2005-05-22 Thread Ludvig Strigeus
How do I run the unit tests in Linux? I've managed to build "tclsqlite3", but where do I go from there? /Ludvig

[sqlite] Slow SQL statements

2005-05-22 Thread Ludvig Strigeus
Hello, Can someone come up with some slow SQL statements (that execute in like 2 seconds) that are not disk bound but CPU bound. Preferably single liners. I'm playing around with a profiler and trying to find bottlenecks in sqlite and optimizing them. /Ludvig

Re: [sqlite] What does this code do?

2005-05-22 Thread D. Richard Hipp
On Sun, 2005-05-22 at 10:19 +0200, Ludvig Strigeus wrote: > Why not pass a single number to sqlite3VdbeRecordCompare instead, that > just says how many fields to compare? That seems simpler. Why was the > current design chosen. > The reason for not passing in a nField value is that the BTree