SELECT order_date, SUM(quantity * widget_price)/100 as income FROM
Purchase_Orders, Purchase_Order_Items, Widgets WHERE order_date =
'2003-01-15' AND Purchase_Orders.purchase_order_id =
Purchase_Order_Items.purchase_order_id AND
Purchase_Order_Items.widget_id = Widgets.widget_id GROUP BY
order_date;
takes about 47 seconds on mySQL, 3 seconds on PostgreSQL and less
than half a second on REAL SQL Server.
I don't want to start a flame and to be really honest I hate raw
numbers, but I can say you that there will be an RB test suite/app
for the REAL SQL Server so you can try your own tests against other
databases and take your decision.
Hi Marco,
Thanks for the insight in the test suite.
I hate the flame wars too and will shut up about this until you have
that test suite/app ready. Right now as a first impression I can
only say that 3 seconds in PostgreSQL for that last SELECT query for
example seems impossibly high. There are only one million records in
the biggest table. Intuitively I would think it should be close to
"instantaneous" as a human perception, and 3 seconds is a "long wait"
as a human perception.
It really does sound like there was either something wrong with your
PostgreSQL setup or you didn't properly use PostgreSQL's features
that allow to improve this. We may dig into this once your test
suite/app is ready.
(I can't speak for MySQL. What's sure is that this last query is
about database performance and not about plugin performance as I
referred to in my original message, which is good. In case any
reader wonders what the difference between these two is I can expand.)
Cheers,
Marc
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
