Hello Pavel, > >* When I implement the same mechanism for saving the*> >* memory database > >back to disk, the size of disk file is 4x of the original*> >* disk file > >size.* > What is "original disk file size" here? Is it an empty database, > database with some data, database with exactly the same data you are > restoring? If the latter then do you restore right over the existing > data? If yes how?
The original database on disk was created from scratch in memory and saved "backup" command in regular "tclsh". Afterwards it was restored using CREATE TABLE in the EDA tool as mentioned below dbcmd eval "CREATE TABLE '$tname' AS SELECT * FROM loadfrom.'$tname'" Once it is restored in the EDA tool memory, it is saved back on disk using the commands I mentioned in the first email. Thanks, Madhur _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
