On 19 Dec 2011, at 7:04pm, Tal Tabakman wrote: > 1. I am using version 3.3.6 of sqlite. > > 2. My journal mode is memory > > 3. I am opening a transaction and then do 50000 inserts before > committing and opening a new transaction > > > given the above, what are the requirnments (disk-wise) when I produce > database with file size of 64 M ?
I hope another person can answer you. But I think perhaps you will temporarily need at least enough space to store the 50,000 rows of data twice. Perhaps an SQLite expert can help. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users