Re: [sqlite] Is it possible to optimize the read performance of a C++ app using sqlite pragma journal_mode = wal & pragma wal_checkpoint?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/25/2011 07:04 PM, Frank Chang wrote: > While writing the records to to the sqlite database we do a commit every > 1 records. >We think we understand that we also need to do a sqlite pragma wal_checkpoint everytime >we do a sqlite database

Re: [sqlite] Is it possible to optimize the read performance of a C++ app using sqlite pragma journal_mode = wal & pragma wal_checkpoint?

On 26 May 2011, at 3:04am, Frank Chang wrote: > In the second phase, we read the sqlite WAL database and try to find > out the duplicates in our input records. Here, we are only reading the sqlite > WAL database. We would like to find out how to optimize the read performance > of the

[sqlite] Is it possible to optimize the read performance of a C++ app using sqlite pragma journal_mode = wal & pragma wal_checkpoint?

Good evening, We are trying to build a C++ deduper application using the latest sqlite release. Our deduper runs in two phases. In the first phase it reads the records to be deduped from a Microsoft DBF file and writes the records into sqlite wal database. While writing the records to to the

Re: [sqlite] How to upgrade from SQLite 3.7.4 to 3.7.6.3

In the meantime, I have found SQLite Expert Personal 3 to be a more stable solution than the firefox plugin. I finally ditched the plugin entirely. http://www.sqliteexpert.com/download.html --- On Wed, 5/25/11, Simon Slavin wrote: > From: Simon Slavin

Re: [sqlite] How to upgrade from SQLite 3.7.4 to 3.7.6.3

On 25 May 2011, at 10:11pm, Long, Matthew wrote: > I have firefox Sqlite manager installed, and I see the Sqlite version: > 3.7.4 installed when I start Sqlite manager. How do I upgrade 3.7.4 to > 3.7.6.3? You can't upgrade, you have to wait for programmers to do it. It is probably using

[sqlite] How to upgrade from SQLite 3.7.4 to 3.7.6.3

Hi All, I have firefox Sqlite manager installed, and I see the Sqlite version: 3.7.4 installed when I start Sqlite manager. How do I upgrade 3.7.4 to 3.7.6.3? When visit the sqlite dowload page, I'm not sure what to install since I installed using a add-on for firefox.

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

Richard, At 13:07 25/05/2011, you wrote: >It turns out that the "expected" behavior does not happen in modern C >compilers. Overflow of signed integers is undefined behavior in C. So if >you have a signed integer overflow, it might wrap the result (the >"expected" >result) or it might

Re: [sqlite] Incorrect left join behavior?

Makes sense. Thanks. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Wednesday, May 25, 2011 9:37 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Incorrect left join behavior? > I can

Re: [sqlite] Incorrect left join behavior?

> I can use two left joins.  While writing the first left join, I discovered > that it is behaving like an inner join. > > select * > from test a >   left join test b on a.component = b.component > where a.machine = 'machine1' >   and b.machine = 'machine2'; By the WHERE condition you limit

[sqlite] Incorrect left join behavior?

Hi, I have a table as below. Note that machine1 has 3 components (1-3), while machine2 has only 1 components (1). Machine Component Version machine1 component1 1 machine1 component2 1 machine1 component3 1 machine2 component1 1 create table test(Machine, Component,

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

Jan Hudec wrote: > (it would be nicest if sqlite could get bitwise not one day). -x-1 is equivalent, assuming two's complement representation. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

Richard Hipp writes: > > On Wed, May 25, 2011 at 4:40 AM, Jan Hudec wrote: > > > Hello All, > > > > Semantics of operations on integers changed between 3.7.5 and 3.7.6. It > > does > > not seem to be mentioned in change log (http://www.sqlite.org/news.html), > > > > 4th

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

On Wed, May 25, 2011 at 4:40 AM, Jan Hudec wrote: > Hello All, > > Semantics of operations on integers changed between 3.7.5 and 3.7.6. It > does > not seem to be mentioned in change log (http://www.sqlite.org/news.html), > 4th bullet here:

[sqlite] Database Locked

I'm using sqlite v3 as database backend for an very small web app (some of 20 concurrent users -really serial access users-).. in Ms. Win xp (my test/develop env.) it work perfectly...my web app can handle that load(and even more by My JMeter Tests)... But on my production environment

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

Radovan Antloga writes: > http://www.sqlite.org/releaselog/3_7_6.html Ok, I see it's mentioned there. Given that it changes semantics I would have expected it to be mentioned more prominently though. Now may I ask why it was done? Are there some known real world cases

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

On 25 mai 2011, at 10:40, Jan Hudec wrote: > Since "integer primary key" is faster than "primary > key (object_id, side)" and since the rows are mostly handled independenty > (and have many other things refer to them), I construct a primary key with: > >object_id | (side << 63) [...] >

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

See this: http://www.sqlite.org/releaselog/3_7_6.html Regards, R.Antloga S, Jan Hudec piše: > Hello All, > > [Is this correct place to report a bug, or can I create it in Fossil > somehow?] > > Semantics of operations on integers changed between 3.7.5 and 3.7.6. It does > not seem to be

[sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

Hello All, [Is this correct place to report a bug, or can I create it in Fossil somehow?] Semantics of operations on integers changed between 3.7.5 and 3.7.6. It does not seem to be mentioned in change log (http://www.sqlite.org/news.html), though it may affect existing applications: * Up to