Re: [sqlite] How to reduce the flash erasing times when I using sqlite

2005-09-11 Thread Mrs. Brisby
Don't? Use a :memory: table or a ramdisk. periodically (or at commit time?) save a copy of the database elsewhere- perhaps in another form- perhaps in a form that's less pleasant to query quickly. On Wed, 2005-09-07 at 14:48 +0800, SH L wrote: > I found sqlite will update some fixed places > freq

[sqlite] 回复: Re: [sqlite] How to reduce the flash erasing times when I using sqlite

2005-09-07 Thread SH L
What about jffs2? I had added it to my system. --- Roger Binns <[EMAIL PROTECTED]>写道: > > The flash will die after a > > while. How can I solve this problem. Thankyou. > > The simplest solution is to use a filesystem with > builtin > wear levelling. (Some flash chips also have it > builtin > suc

Re: [sqlite] How to reduce the flash erasing times when I using sqlite

2005-09-07 Thread Roger Binns
The flash will die after a while. How can I solve this problem. Thankyou. The simplest solution is to use a filesystem with builtin wear levelling. (Some flash chips also have it builtin such as those from M-Systems). You can get file systems that do wear levelling for most embedded operating

[sqlite] How to reduce the flash erasing times when I using sqlite

2005-09-06 Thread SH L
I found sqlite will update some fixed places frequently in the database file when insert,update or even create operation happens.It means that if my database file in flash and I do high-frequency insert or update(about 3000/day).The flash will die after a while.How can I solve this problem. Thanky