Yes to both questions. -Randy
-----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Friday, July 15, 2005 6:37 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to delete all rows in table (TRUNCATE) without creating journal file(s)? > Disabling the journal would roughly half the amount > of disk (flash) I/O required. If it currently takes > 2 minutes to delete, disabling the journal would > reduce that to about 1 minutes. Still a long time. You were aware that flash memory has a limited number of write cycles before it fails right? Is your flash disk backed with RAM?
