Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

2009-06-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joanne Pham wrote: > I send this email to the group to ask the question just in case if someone in > group has done the bench mark then it will save my time. You asked about "SQLite database operation like Read/Write". While technically that

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

2009-06-01 Thread John Elrick
Joanne Pham wrote: > Hi All, > We are currently using SQLite 3.59 for our product and We will have the > release in middle of June. > If you must ask this question and your release is two weeks away, the answer is "do not upgrade". We have a battery of unit tests we run, I have complete

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

2009-06-01 Thread Kees Nuyt
On Mon, 1 Jun 2009 15:39:11 -0700 (PDT), Joanne Pham wrote: > I send this email to the group to ask the question > just in case if someone in group has done the > benchmark then it will save my time. You are the only one who can run that benchmark, because no one else

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

2009-06-01 Thread P Kishor
> > From: Roger Binns <rog...@rogerbinns.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Sent: Monday, June 1, 2009 3:21:10 PM > Subject: Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59 > >

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

2009-06-01 Thread Joanne Pham
3:21:10 PM Subject: Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joanne Pham wrote: > Do you think that upgrade the SQLite to newer version 3.6.14.2 from 3.5.9 > will be help to improve the SQLite database operation like Read

Re: [sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

2009-06-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joanne Pham wrote: > Do you think that upgrade the SQLite to newer version 3.6.14.2 from 3.5.9 > will be help to improve the SQLite database operation like Read/Write? What results did you see when you tried the newer SQLite against your queries

[sqlite] Should we upgrade the SQLite to 6.6.14.2 from 3.59

2009-06-01 Thread Joanne Pham
Hi All, We are currently using SQLite 3.59 for our product and We will have the release in middle of June. We have been facing a lot of problem regarding performance and next release we can to able to scale up to 4 times faster than previous release. Do you think that upgrade the SQLite to