Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Thu, Apr 18, 2013 at 3:27 AM, Mario M. Westphal wrote: > > After downloading and compiling in the SQLite 3.7.16.2, we have a problem. > > The INSERT statement which takes only a few seconds with previous builds > now does not return, at least not within several minutes. > It's

Re: [sqlite] sqlite abnormal IO writing

My database connection option: PRAGMA synchronous = NORMAL; PRAGMA journal_mode = OFF; PRAGMA auto_vacuum = 0; In windows process monitor ,it show 2.5M writing ,but the database file increase only 10k or so. So those IO writing is very abnormal IMO. At 2013-04-22 03:24:43,"Stephen

Re: [sqlite] sqlite abnormal IO writing

Here is the schema of table: CREATE TABLE statdata ( typeINT, seq INT, uid VARCHAR( 36 ), counter INT, PRIMARY KEY ( type, seq ASC ) ); before my modify: 500 rows at maximum, query:insert or replace (...) in batch mode take

Re: [sqlite] sqlite abnormal IO writing

>On Sun, 21 Apr 2013 11:15:23 +0800 (CST), 刘运杰 >wrote: >Ok,I do not make my means clearly. I mean 60 seconds after my >program started,not token 60 seconds to load database file. ... >Now,I modify the implement of batch query, it take about one >second and 70k IO writing.So

Re: [sqlite] sqlite abnormal IO writing

You know, this kind of "smells" like a full sync, non transactioned, single inserts problem. Basically, you open the connection to the database, start throwing inserts at it without a transaction around each insert. To make matters worse (For time anyways) you've probably got full sync on, and

Re: [sqlite] sqlite abnormal IO writing

FAQ 19 applies also to SAVEPOINT/RELEASE, not only to BEGIN/COMMIT, right? On Sun, Apr 21, 2013 at 9:35 AM, Kees Nuyt wrote: > On Sun, 21 Apr 2013 11:15:23 +0800 (CST), ?? > wrote: >> >> Ok,I do not make my means clearly. I mean 60 seconds after my >>

Re: [sqlite] sqlite abnormal IO writing

On 21.04.2013 05:15, 刘运杰 wrote: Ok,I do not make my means clearly. I mean 60 seconds after my program started,not token 60 seconds to load database file. Now, I got the reason of sqlite abnormal IO writing,it about batch insert. Here is my usecase: One table about 4 column and 500 row,the

Re: [sqlite] Execute the file in minicom(SBC)

My problem solved...I try to copy the file sqlite lib from usr/local/lib to usr/lib/. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Execute-the-file-in-minicom-SBC-tp68318p68331.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] sqlite abnormal IO writing

刘运杰 wrote: >One table about 4 column and 500 row,the content of every row no exceed >100 byte, every time I update the whole table using batch query. > >It should take about one second and 100k IO writing on estimate,BUT it >sustained about 20 second and wrote about 2.5M actually. Please show

Re: [sqlite] sqlite abnormal IO writing

On Sun, 21 Apr 2013 11:15:23 +0800 (CST), ?? wrote: > > Ok,I do not make my means clearly. I mean 60 seconds after my > program started,not token 60 seconds to load database file. > > Now, I got the reason of sqlite abnormal IO writing,it about > batch insert. Here is my