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,...)?
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 ?
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
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
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
-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