> > > I don't know what was the scenario Michael had in mind, but I'd create a > temporary table, fill it with data (there will be no single change to the > main db ) then after 2 minutues work perform INSERT INTO MyMainTable SELECT > * FROM MyTempTable. So this is the query that actually affects the contents > of the main db (and writes also to the journal file). This one can be > interrupted with a power failure and in this case on a next open sqlite > will > try to restore the state that was before the transaction started > > Max > > Yes, it seems I should just leave Sqlite the way it is and instead store the 2 min data in temporary tables and then insert it in one go every 2 minutes.
Thanks Pankaj _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
