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 > 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. Thankyou. > > > > ___________________________________________________________ > 雅虎免费G邮箱－No.1的防毒防垃圾超大邮箱 > http://cn.mail.yahoo.com
