Re: [sqlite] How Do i use sqlite3 log?

2011-10-05 Thread 张一帆
Thank you very much for reply. yes.i have tried transaction ,and my database is created by the name ':memory:'. now it takes about 5 minutes to insert 20 thousand record. it is really slow. by the way,how do i use 'pragma'? like sqlite_exec(handle,PRAGMA cache_size = 4096,...)?

Re: [sqlite] How Do i use sqlite3 log?

2011-10-05 Thread Simon Slavin
On 5 Oct 2011, at 10:06am, 张一帆 wrote: Thank you very much for reply. yes.i have tried transaction ,and my database is created by the name ':memory:'. now it takes about 5 minutes to insert 20 thousand record. it is really slow. Are you running this on a computer or a different device ?

Re: [sqlite] How Do i use sqlite3 log?

2011-10-02 Thread 张一帆
thank you very much for replying me. my application is really very slow when insert data,and i have tried translation. but it does not increase speed. so what can i do? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How Do i use sqlite3 log?

2011-10-02 Thread Kees Nuyt
On Sun, 02 Oct 2011 21:20:27 +0800, ?? zyf01...@gmail.com wrote: thank you very much for replying me. my application is really very slow when insert data, and i have tried translation. I guess you mean transaction, not translation? but it does not increase speed. so what can i do? Did

[sqlite] How Do i use sqlite3 log?

2011-10-01 Thread 张一帆
How Do i use sqlite3 log? i want to check my pro. thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How Do i use sqlite3 log?

2011-10-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/01/2011 02:35 AM, ??? wrote: How Do i use sqlite3 log? i want to check my pro. thanks Which bit of the of the documentation page needs to be improved? http://www.sqlite.org/c3ref/log.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG