Re: [sqlite] How should I use parenthesis?

Select A.*,B.* from A left outer join B on x in (subselectA) and y in (subselectB) Union all Select A.*,B.* from B left outer join A on x in (subselectD) and y in (subselectC) It seems strange that there is no condition limiting which rows from A and B match, which makes the LEFT OUTER JOIN

Re: [sqlite] How should I use parenthesis?

Perhaps you want: select * from ( select * from A where x in (subselectA) left outer join ( select * from B where y in (subselectB) ) as a on -- something ) as A1 UNION ALL select * from ( select * from B where y in (subselectC) left

Re: [sqlite] How should I use parenthesis?

On 1/27/2014, 9:57 AM, Jean-Christophe Deschamps wrote: I'm trying to find the correct syntaxt for this, but I hit a syntax error each time: either SQLite shokes on outer parenthesis or on union all. Try something like this, which is a minimal change from yours: (select * from (select * from

[sqlite] (no subject)

I have two tables: ARB KEY (PRIMARY KEY) ASSIGN (NOT NECESSARILY UNIQUE) DMC KEY (NOT UNIQUE) ASSIGN (NOT UNIQUE) VALUE I need to report all the records from ARB, and sum up the values if the keys match OR if the keys don't match, then sum up the values where the ASSIGN matches, but

Re: [sqlite] (no subject)

On 1/28/2014 2:26 PM, David Bicking wrote: I have two tables: ARB KEY (PRIMARY KEY) ASSIGN (NOT NECESSARILY UNIQUE) DMC KEY (NOT UNIQUE) ASSIGN (NOT UNIQUE) VALUE I need to report all the records from ARB, and sum up the values if the keys match OR if the keys don't match, then sum

Re: [sqlite] (no subject)

On Tue, 1/28/14, Igor Tandetnik wrote: Subject: Re: [sqlite] (no subject) To: sqlite-users@sqlite.org Date: Tuesday, January 28, 2014, 2:41 PM On 1/28/2014 2:26 PM, David Bicking wrote: > I have two tables: > > ARB >   

[sqlite] performance difference based on the sqlite configuration?

I do have a similar issue. I am finding it hard which is the best configuration for most of the large scale application. Our database size grows from 0 – 45 GB . As the database size grows, performance seems to be degrading.   Major operations include insertion/read/delete   Current settings:  

[sqlite] Performance based on Sqlite Configuration

I am finding it hard which is the best configuration for most of the large scale application. Our database size grows from 0 – 45 GB . As the database size grows, performance seems to be degrading. Performance of the same application is better when it compared to Sql Server. I am in the middle

Re: [sqlite] performance difference based on the sqlite configuration?

On Tue, Jan 28, 2014 at 6:57 PM, veeresh kumar wrote: > I do have a similar issue. I am finding it hard which is > the best configuration for most of the large scale application. Our > database > size grows from 0 - 45 GB . As the database size grows, performance seems > to