Re: [sqlite] What does this code do?

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 layer

[sqlite] Slow SQL statements

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

[sqlite] unit tests

How do I run the unit tests in Linux? I've managed to build tclsqlite3, but where do I go from there? /Ludvig

Re: [sqlite] unit tests

How do I run the unit tests in Linux? make test

Re: [sqlite] unit tests

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

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 PROTECTED]

[sqlite] Behavior on corrupt database

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] Behavior on corrupt database

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] How to lock my database?

How to lock my database? Thanks for help!

[sqlite] Transaction for single SQL query?

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

Re: [sqlite] How to lock my database?

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

Re: [sqlite] Slow SQL statements

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 question