From: sdalemorrey@gmail.com
Subject: Re: Ada and PL/pgSQL ?
Date: Fri, 9 May 2014 12:59:30 -0700 (PDT)
Date: 2014-05-09T12:59:30-07:00 [thread overview]
Message-ID: <907541b2-62f6-449e-87bf-7706b1457922@googlegroups.com> (raw)
In-Reply-To: <49354f93-75ef-4b1c-90a3-0fdedc7e36f3@googlegroups.com>
> Unless you are sending a massive amount of data to ther server,
>
> I think you are bitten by mysql performance.
>
> /Björn
No there are similar results when exporting the schema from MySQL to Postgres. The fact is there is only so much you can logically do in a single query. 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 involved 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.
next prev parent reply other threads:[~2014-05-09 19:59 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-05-09 16:26 Ada and PL/pgSQL ? sdalemorrey
2014-05-09 18:02 ` björn lundin
2014-05-09 19:59 ` sdalemorrey [this message]
2014-05-09 21:14 ` björn lundin
2014-05-10 9:37 ` Dirk Heinrichs
2014-05-10 10:40 ` Mike H
2014-05-10 11:04 ` björn lundin
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox