-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ian Frosst wrote:
> My question is; am I assessing the situation correctly, and if so, is there
> anything I can do to avoid this rather nasty situation? I would rather not
> take the periodic-commit approach, and increasing the page cache size would
> potentially cause the use of more memory than I can spare. Disk usage,
> however, is not a problem; I can use as much as is necessary.
You can open a second connection and make another database that you do
all your writing to, using as small a page cache as you want. When done
add the data in your first connection. Basically do this ("main" is the
name of the first database):
attach second.db as second
insert into main.table (select * from second.table)
detach second
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkl/9xQACgkQmOOfHg372QQANACfZqk1FvGphzWH+cTZU0iHw16w
Ff4AmgNgL6XmFtzBoMxUGadS8M5rO+Og
=WsGj
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
