Am Sat, 9 Jan 2010 22:00:04 +0100 schrieb Carsten Giesen: [Transactions]
> Thanks. That's rock .... > Greate. Next, play with some PRAGMA settings to achieve even more speed, especially: PRAGMA cache_size = Number-of-pages; PRAGMA page_size = bytes; Also (it's not clear whether you do this already) use prepared statements (sqlite3_prepare*) with parameters (sqlite3_bind_*) instead of building a new SQL string for each row to be inserted. HTH, Wolfgang _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
