> One thing I can highly recommend on embedded systems, especially flash > based ones, is turn pragma synchronous to off. Having sqlite write every > record modification to the flash, is a stunningly expensive process, > even when it's all encapsulated in a large transaction. Let linux handle > the synchronisation and write caching for you. A lot less robust, but, > the benefits more than outweighed the cost. If you need guaranteed write > to disk, then perform the synch yourself.
> Cost vs benefit and all that guff. That's sounds like good advice. I'll do that. Working with flash in this way is going to be a challenge. With limited number of writes in a lifetime (this device needs to last approx 20 years...) I will have to make some major design decisions around how I handle the writes. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
