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

] Does sqlite caches data to speed up transaction This isn't unexpected at all. The overhead of using a database (even SQLite) is much much higher than seeking to an area of an open file and reading some bytes out of it. From: devesh tiwari <[EM

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

On Mon, 29 Sep 2008 12:14:42 -0700 (PDT), devesh tiwari <[EMAIL PROTECTED]> wrote in : >I am not seeing this performance difference in write >but in reading database. Following is the sequence >i am performing for reading: > >1. sqlite3_open() >2. sqlite3_prepare() >3.

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

:15 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Does sqlite caches data to speed up transaction I am not seeing this performance difference in write but in reading database. Following is the sequence i am performing for reading: 1. sqlite3_open() 2. sqlite3_prepare() 3. sqlite3_bind_i

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

primary key error (Mariano Martinez > Peck) >2. Re: Duplicated primary key error (P Kishor) >3. Re: Duplicated primary key error (Mariano Martinez > Peck) > 4. Does sqlite caches data to speed up transaction time? > (devesh tiwari) >5. Re: Does sql

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

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