From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM
	autolearn=unavailable autolearn_force=no version=3.4.4
X-Received: by 10.236.140.42 with SMTP id d30mr6018239yhj.2.1399665571352;
        Fri, 09 May 2014 12:59:31 -0700 (PDT)
X-Received: by 10.182.28.1 with SMTP id x1mr85689obg.28.1399665571056; Fri, 09
 May 2014 12:59:31 -0700 (PDT)
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!news.eternal-september.org!feeder.eternal-september.org!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!hw13no1891067qab.0!news-out.google.com!gi6ni796igc.0!nntp.google.com!r10no2510446igi.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.lang.ada
Date: Fri, 9 May 2014 12:59:30 -0700 (PDT)
In-Reply-To: <49354f93-75ef-4b1c-90a3-0fdedc7e36f3@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com;
 posting-host=71.219.231.11;
 posting-account=X7Y-0AoAAABSgWfgVpaegSDud7e4NIYx
NNTP-Posting-Host: 71.219.231.11
References: <304f2721-64bc-4959-a7e8-0cc29cf5204f@googlegroups.com>
 <49354f93-75ef-4b1c-90a3-0fdedc7e36f3@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <907541b2-62f6-449e-87bf-7706b1457922@googlegroups.com>
Subject: Re: Ada and PL/pgSQL ?
From: sdalemorrey@gmail.com
Injection-Date: Fri, 09 May 2014 19:59:31 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1938
X-Received-Body-CRC: 2829906859
Xref: news.eternal-september.org comp.lang.ada:19766
Date: 2014-05-09T12:59:30-07:00
List-Id: <comp.lang.ada>


> Unless you are sending a massive amount of data to ther server,
>=20
> I think you are bitten by mysql performance.
>=20
> /Bj=F6rn

No there are similar results when exporting the schema from MySQL to Postgr=
es.  The fact is there is only so much you can logically do in a single que=
ry.  You  can index and join and filter and sort etc.  But when push comes =
to shove you need to implement business logic somewhere.

The tables are simple and not at all complex.  There are two tables involve=
d a transactions table and an order table.

The transactions table reflect credits/debits against accounts, whereas the=
 orders table represents a literal "filled out order form".

It can't really be simplified much more than that.