Re: [sqlite] sqlite abnormal IO writing

2013-04-20 Thread 刘运杰
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 content of every row no exceed 100

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

2013-04-20 Thread Gilles Ganault
On Fri, 19 Apr 2013 16:41:53 -0700, "Joe Mistachkin" wrote: >Actually, ALL the non-static packages on the download page require the MSVC >runtime libraries of the appropriate version to be installed. > >The download page does mention these requirements in each applicable

Re: [sqlite] sqlite abnormal IO writing

2013-04-20 Thread Stephen Chrzanowski
Attachments cannot be put into this mailing list. Please either upload to a service like PasteBin or put a copy in your PUBLIC directory in DropBox and provide us with a link. Try using a different application, like the Command Line Interface (CLI) and open it through there and see if you get a

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

2013-04-20 Thread Stephan Beal
On Sat, Apr 20, 2013 at 6:04 PM, Newbie89 wrote: > bash-2.05a# ldd ./check > libsqlite3.so.0 => not found > libc.so.6 => /lib/libc.so.6 (0xf760a000) > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0xf772b000) > Then try this: export

[sqlite] sqlite abnormal IO writing

2013-04-20 Thread 刘运杰
Sqlite version : "3.7.16" (Qt 4.8.2 ) OS: Windows XP Databse PRAGMA: PRAGMA synchronous = NORMAL; PRAGMA journal_mode = OFF; PRAGMA auto_vacuum = 0; the process: I wrote one application using Qt 4.8.2 and Sqlite "3.7.16". Every time after my program start up 60 second, the sqlite database

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

2013-04-20 Thread Newbie89
here is my output: bash-2.05a# ldd ./check libsqlite3.so.0 => not found libc.so.6 => /lib/libc.so.6 (0xf760a000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0xf772b000) -- View this message in context:

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

2013-04-20 Thread Stephan Beal
On Sat, Apr 20, 2013 at 10:59 AM, Newbie89 wrote: > 1)cd /usr/lib/libsqlite3.so > i overlooked that: that cannot have worked because libsqlite3.so is a file, not a directory. Try: cd /usr/lib ln -s libsqlite3.so libsqlite3.so.0 Then: cd rm libsqlite3.so to remove the

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

2013-04-20 Thread Stephan Beal
On Sat, Apr 20, 2013 at 10:59 AM, Newbie89 wrote: > bash-2.05a# ./check > ./check: error while loading shared libraries: libsqlite3.so.0: cannot open > shared object file: No such file or directory > What does this output: ldd ./check ? That will show you which

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

2013-04-20 Thread Newbie89
Hi,thanks for your reply. I found the file under /usr/lib... then I 1)cd /usr/lib/libsqlite3.so 2)ln -s libsqlite3.so libsqlite3.so.0 the problem still exist... bash-2.05a# ./check ./check: error while loading shared libraries: libsqlite3.so.0: cannot open shared object file: No such file or

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

2013-04-20 Thread Stephan Beal
On Sat, Apr 20, 2013 at 8:53 AM, Newbie89 wrote: > error while loading shared libraries: libsqlite3.so.0: cannot open shared > object file: No such file or directory > How can I fix the problem? > Does your system have a file called libsqlite3.so without the ".0" on the

[sqlite] Execute the file in minicom(SBC)

2013-04-20 Thread Newbie89
I'had find some problem when execute the file.As shown below: error while loading shared libraries: libsqlite3.so.0: cannot open shared object file: No such file or directory How can I fix the problem? Any help? Thanks -- View this message in context: