Hello, new to the list and to SQLite. A little background... writing C library for an embedded system (ARM) which started in mysql but now we want something much lighter.

Anyway, things are going pretty well. We had an existing library and application we ported to use SQLite which was already based on an existing table structure. In a few tables we have status columns where the data is not need for long term storage. The data can always be restored and can change often. We were curious if anyone knew of a way to prevent updates to a single column from being written to disk(flash) and just have it written to the cache? Most of our runtime writes will be of the status variety. Configuration of the system is stored and needs to be protected. I know it would be simple to separate the column out and create a :memory db, but that would require numerous changes to our system (easily doable, just not at the moment) So I was just checking the community to see if anyone has any ideas or thoughts on this!

Thanks in advance.

Jeff
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to