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
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
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
How to lock my database?
Thanks for help!
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]>
If I corrupt my database in certain ways, I can make Sqlite crash. Is
this by design, or is it a bug?
/Ludvig
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
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
> How do I run the unit tests in Linux?
make test
How do I run the unit tests in Linux?
I've managed to build "tclsqlite3", but where do I go from there?
/Ludvig
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
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
12 matches
Mail list logo