Richard Hipp-3 wrote
> What is your page size?
1024
Richard Hipp-3 wrote
> Your original post said you inserted two rows for each transaction.
> How big are those two rows?
Sorry for misleading information. Here is a more formal algorithm:
foreach table
{
BEGIN
insert all downloaded rows
COMMIT
}
No. of downloaded rows per table is unknown. In this extreme case it was
3.5+ mil records.
I understand that the WAL log must take a lot of space. What I don't
understand is that it was 7x larger than the resulting DB size. (Actual
quotient is even larger because I compared to the DB size that contained
also other tables.)
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Huge-WAL-log-tp79991p80017.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
