Re: [sqlite] Sporadic freezes of sqlite

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 my

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

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 TEMP_

[sqlite] .genfkey & quoted table names

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)); .genfke

Re: [sqlite] record order in select

> 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 version,

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

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 transactions... http://www.oracl

Re: [sqlite] record order in select

"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 want a particular order (by

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

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 int

Re: [sqlite] Sporadic freezes of sqlite

> 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 proble

[sqlite] record order in select

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

"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 extension on both wi

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

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 i