From: Steffen Boehme <Steffen@boemm.de>
To: pgsql-sql@postgresql.org
Subject: Performance of Views
Date: Mon, 28 Feb 2005 18:31:23 +0100
Message-ID: <38h2r6F5k5o1dU1@individual.net> (raw)
Hello there,
i have a short question ...
I have a few tables (at the moment "only" 3 for testing), over which
will by made a query in this form:
SELECT
a.orderitem_id,
a.transaction_id,
a.order_id,
a.shop_id,
a.quantity,
a.price,
b.affiliate_id,
c."type"
FROM
ss_order_orderitems a
LEFT JOIN ss_order_affiliate_tracking b ON a.order_id = b.order_id,
ss_shops c
WHERE
(a.order_id = b.order_id OR b.order_id IS NULL) AND
a.shop_id = c.shop_id;
The query will get later a few more conditions ...
Now is the problem, that the performance is not realy good ... and i
think about the best solution for such a query and found three possibilitys:
1. a simple select over the three tables (one of them contains 160000
entrys in the moment and it's growing) in the form like above (the db is
mysql 4.1.x)
I think this solution is not very perfomant ...
2. move the data to a postgresql-db with the same structur and create a
view, wich makes the same query ...
Is the performance for the same query different between a simple select
and a view!?
If so, i can forget the view ...
3. put the data with the above query in one big table ...
I know, thats no good db-structur, but i don't know how i could make it
better ...
The main-question at the moment iss ...
Is the performance of the View-Method better then the first Method on
the existing tables!?
I hope of a view hints ...
Thanks
Steffen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Steffen@boemm.de
Subject: Re: Performance of Views
In-Reply-To: <38h2r6F5k5o1dU1@individual.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox