Re: [sqlite] Sporadic freezes of sqlite

2009-04-24 Thread Pavel Ivanov
Unfortunately these two options are not for me. I'm not in control of servers hardware, so my application should work on the given servers and nobody will adjust them for my application. And about first option, I believe what you say is to use in-memory database for intensive operations. But all

Re: [sqlite] TEMP_STORE not working ?(3.5.9)

2009-04-24 Thread Kris Groves
After code reading, I have discovered that the culprit is the statement journal. Regardless of TEMP_STORE = MEMORY or not, the statement journal, which is treated differently than a regular journal file, is placed in a temporary file. This effectively kills the usefulness and purpose of the

[sqlite] .genfkey & quoted table names

2009-04-24 Thread Thomas Henlich
Hi, I found a bug in the .genfkey functionality: If a foreign key constraint references a table with a quoted table name, the .genfkey command will fail on that constraint. Example: create table "t.3"(c1 primary key); create table t13(c1, foreign key(c1) references "t.3"(c1));

Re: [sqlite] record order in select

2009-04-24 Thread Eric Minbiole
> If "order by" isn't used in a select statment, does the result records > ordered in rowid? If you omit an ORDER BY clause, the order of the resulting data is undefined. It might happen to be ordered by rowid in some cases, but this is not guaranteed. (Might change in a future

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-24 Thread P Kishor
On Fri, Apr 24, 2009 at 5:27 AM, John Stanton wrote: > Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by > without the advanced features of Sqlite, then use Berkely and take > advantage of its simplicity and faster execution. BDB does support

Re: [sqlite] record order in select

2009-04-24 Thread Igor Tandetnik
"Wenton Thomas" wrote in message news:790786.83985...@web111003.mail.gq1.yahoo.com > If "order by" isn't used in a select statment, does the result > records ordered in rowid? Generally, no. It could accidentally happen this way, but there's no guarantee. If you

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-24 Thread John Stanton
Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by without the advanced features of Sqlite, then use Berkely and take advantage of its simplicity and faster execution. Note that for best performance an Sqlite application should group database inserts, deletes and updates

Re: [sqlite] Sporadic freezes of sqlite

2009-04-24 Thread January Weiner
> I have an application written using sqlite. It writes into the > database very intensively. And I noticed that it works nice and very > fast but from time to time it just freezes for several seconds (I've > registered freezes up to 8 secs). After some tracing of sqlite code I had the same

[sqlite] record order in select

2009-04-24 Thread Wenton Thomas
If "order by" isn't used in a select statment, does the result records ordered in rowid? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sporadic freezes of sqlite

2009-04-24 Thread Olaf Schmidt
"D. Richard Hipp" schrieb im Newsbeitrag news:fb9c47d5-1b72-4574-bb44-4f0d6685f...@hwaci.com... > FWIW, we are in the process of "productizing" the > test_async.c asynchronous VFS for SQLite. > The new async VFS might be available as a compile-time > option or as a loadable

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-24 Thread liubin liu
Thanks I amend the code according to your message. Marcus Grimm wrote: > > in your test code I see that you open the sqlite DB > each time you perform the single query. > I guess it would be fair to open the sqlite DB only once > outside your test loop. > 2nd: You query against ID without an