Hi, On Fri, Apr 24, 2009 at 11:35 AM, liubin liu <7101...@sina.com> wrote: > > our project is using sqlite3, but found that the speed is too slow. > I just tested the BerkeleyDB, and found that the speed is very fast. But I > knew the sqlite3 is fast enough. And so I'm confused. > I may be using sqlite3 in wrong way?
Instead of using sqlite3_mprintf() and sqlite3_exec() for your insert statements, try using prepared statements. Regards, Eugene Wee _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users