Hi all, We have an embedded device where we continuously receive latest values from our process. There are no new records added, but the existing values are updated almost every second. I thought of using sqlite as in-memory database for recording these values (so that writes to the flash drive are minimized) and then flushing these values after a fixed period (not every 1 second) to the database in the flash drive (so that the latest values are not lost in case of a restart). These values should also be read back during the next cycle of the process. The time required for flushing is critical since there can be a power failure condition and the changed data need to be saved in the flash drive within a very short time.
Is it possible to flush only the changed values from the in-memory database to the hard-disk and not backup the whole database (may be using something like a transaction log)? Is there some built-in function for this? Is it possible to have a disk based database, with the WAL file residing in the RAM? In this case less IO cycles are required and the back-upping of data to flash drive is simpler. What other possibility do I have to minimize the write cycles to the flash memory? Thank you, Rojo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
