Re: [sqlite] Does sqlite caches data to speed up transaction time?

On Mon, 29 Sep 2008 03:44:46 -0700 (PDT), devesh tiwari <[EMAIL PROTECTED]> wrote in [EMAIL PROTECTED], General Discussion of SQLite Database : >Hi all, > I am working on an application that frequently uses > multiple files for storing and retrieving data.Now > the number of files to store data as

Re: [sqlite] Does sqlite caches data to speed up transaction time?

On Mon, Sep 29, 2008 at 03:44:46AM -0700, devesh tiwari scratched on the wall: > Hi all, > When I used sqlite to store data, I discovered that writing/reading > data using sqlite is vary slow as compared to direct reading/writing > file(in my case 10 times slower). > > I wonder if sqlite is really

[sqlite] Does sqlite caches data to speed up transaction time?

Hi all, I am working on an application that frequently uses multiple files for storing and retrieving data.Now the number of files to store data as reached around 150 and it is becoming difficult to handle multiple files so i decided to move to a database system. When I heard of sqlite, I though