Re: [sqlite] SQlite on flash filesystem

2014-08-19 Thread Richard Hipp
On Tue, Aug 19, 2014 at 10:38 AM, Richard Hipp wrote: > > > > On Tue, Aug 19, 2014 at 10:34 AM, Levente Kovacs > wrote: > >> I started to worry about this issue, because I am in a middle of an >> application development, and yesterday, it started to work,

Re: [sqlite] SQlite on flash filesystem

2014-08-19 Thread Richard Hipp
On Tue, Aug 19, 2014 at 10:34 AM, Levente Kovacs wrote: > I started to worry about this issue, because I am in a middle of an > application development, and yesterday, it started to work, and I only > SELECT > a few times, and it makes a noticeable disk access. I'm still

Re: [sqlite] SQlite on flash filesystem

2014-08-19 Thread Levente Kovacs
I started to worry about this issue, because I am in a middle of an application development, and yesterday, it started to work, and I only SELECT a few times, and it makes a noticeable disk access. I'm still on magnetic HDD, but the application will be running on SSD or Flash drive. Let me start

Re: [sqlite] SQlite on flash filesystem

2014-08-16 Thread Howard Chu
Simon Slavin wrote: On 16 Aug 2014, at 9:32pm, Baruch Burstein wrote: On Fri, Aug 15, 2014 at 10:45 AM, Levente wrote: I am thinking about putting an SQLite database on a flash drive (SD card). I would like to know what kind of file system is

Re: [sqlite] SQlite on flash filesystem

2014-08-16 Thread Simon Slavin
On 16 Aug 2014, at 9:32pm, Baruch Burstein wrote: > On Fri, Aug 15, 2014 at 10:45 AM, Levente wrote: > >> I am thinking about putting an SQLite database on a flash drive (SD card). >> I would like to know what kind of file system is the optimal. I

Re: [sqlite] SQlite on flash filesystem

2014-08-16 Thread Baruch Burstein
On Fri, Aug 15, 2014 at 10:45 AM, Levente wrote: > I am thinking about putting an SQLite database on a flash drive (SD card). > I would like to know what kind of file system is the optimal. I want to > query a lot, and insert or update a few times per minute. > Not

[sqlite] SQlite on flash filesystem

2014-08-15 Thread Levente
I am thinking about putting an SQLite database on a flash drive (SD card). I would like to know what kind of file system is the optimal. I want to query a lot, and insert or update a few times per minute. The goal is to minimize disk writes, which leads the FLASH to wear out. After some googling