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
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
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:
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
>
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
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
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
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
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
9 matches
Mail list logo