Hi, > What about jffs2? I had added it to my system.
I'm using jffs2 in an embedded linux-arm application I'm putting together with sqlite. I'm still in the early stages so don't have much sqlite specific info. We have found that the wear leveling/garbage collection in jffs2 works a lot better if you have a lot of spare space on your filesystem. This avoids sectors being erased repeatedly. I would have thought that if you keep the number of transactions down it would help enormously. With the number of updates/inserts you are trying to do you may need to think about storing the database in memory and synching with the backing store on a regular basis. hope this helps, Dave
