-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kyle Cronin wrote: > In essence what I'm looking for is a way to defer database writes in a > process so that they can all be done at once. However, while I'm > accumulating update queries,
Why not attach a memory database and accumulate your updates in there. Once ready you do something like: INSERT INTO permanent_table SELECT * from memdb.table You could also attach another disk database and accumulate updates in there, periodically copying across to the main database if you don't want to lose the accumulating updates. Or you could follow the sage advice about premature optimization and actually wait till you have problem and then address whatever that problem turns out to be :-) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkeNRgACgkQmOOfHg372QQKXgCgv85hEEn34nilUFDKa3F2WKTi u/UAn16lKXP3N3NWQnTgRvPd6aZNc9ZW =rBw6 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
