答复: [sqlite] multi_thread for writing

to prevent infinite loops. Also backing out of your multiple successful calls to sqlite3_steps() after a single call in a nested loop fails further complicates things, I think. Try use the sqlite3_busy_timeout() or sqlite3_busy_handler() instead. - Kervin RexChan(TP/HK) wrote: > Hi all, > >

[sqlite] multi_thread for writing

Hi all, I meet the problem of multi_thread writing in version 3.2.1. First I create two threads A and B and each thread has its own db structure. each thread uses the following SQL commands to do the insert action. BEGIN; . insert record 200 times . . END; Thread A does the insert first an

[sqlite] about ROWID after vacuum

Hi all, I have a problem about ROWID after vacuum. The sqlite version is 2.8.16 the case is: I create a table "test" and has one column "a" by SQL statement "create table test (a Text); I added an 5 records to the table column "a" by SQL statement "insert into test values('a')"; Then I read the

[sqlite]AutoVacuum in version 3

Hi all, In version 3.x, there is an autovacuum for free used space. What is the maximum space for the autovacuum consumed? For example, if one record is deleted from 1000 records and the vacuum will be automatically(autovacuum) operated, does the maximum used space for autovacuum operation is

[sqlite]change the location of journal file

Hi all, Could the location of journal file be changed? I modified the code in pager.c and the journal file places to the different folder but database image is malformed when opening database.Have any solutions of changing the location of journal file? Best regards, Kei --