I would also like to know:
#1 How long does it take if you remove the transaction? (in other words is it really working?) #2 What does your TABLE look like? #2 What does your INSERT look like? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Wednesday, October 05, 2011 5:11 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] How Do i use sqlite3 log? 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 ? What operating system are you using ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users