On Jul 1, 2008, at 12:16 PM, Stephen Woodbridge wrote: > >> On Jul 1, 2008, at 11:03 AM, Martin.Engelschalk wrote: >>> Because I can in many cases calculate in advance the size to which >>> the >>> file will grow, i would like to reserve the disk space before >>> inserting >>> all the data. Can this be done? >> > Would something like this work (on linux)? > > dd if=/dev/zero of=mydatabase.db bs=1024 count=65536 > > would create a file that is 64MB in size and zero it out. I'm not use > how sqlite would react to being given a preallocated but empty file > that > exists.
No. SQLite sees a file of zeros as a corrupt database. The internal structure of the file must be correctly initialized. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
