Anthony W. Youngman wrote:
In article <[EMAIL PROTECTED]>, Lauri Pietarinen
[EMAIL PROTECTED]> writes
Anthony W. Youngman wrote:
In article <[EMAIL PROTECTED]>, Lauri Pietarinen
<[EMAIL PROTECTED]> writes
Anthony W. Youngman wrote:
Well, if
Anthony W. Youngman wrote:
In article <[EMAIL PROTECTED]>, Anthony W. Youngman
<[EMAIL PROTECTED]> writes
Really, however you calculate it, it is an order of magnitude less
than your alternative.
And please don't tell me that using indexes is not fair or not in the
spirit of the
relational mod
Marsh Ray wrote:
Lauri Pietarinen wrote:
The theory, indeed, does not say anything about buffer pools, but by
decoupling logic
from implementation we leave the implementor (DBMS) to do as it feels
fit to do.
As DBMS technology advances, we get faster systems without having to
change our
Anthony W. Youngman wrote:
In article <[EMAIL PROTECTED]>, Lauri Pietarinen
<[EMAIL PROTECTED]> writes
Okay. Give me a FORMULA that returns a time in seconds for your query.
Let's assume I want to print a statement of how many invoices were sent
to a customer, along with v
Bob Badour wrote:
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Bob Badour wrote:
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I could now denormalise OrderDetail so that it cont
Bob Badour wrote:
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I could now denormalise OrderDetail so that it contains cust_id also
and cluster by cust_id
(might cause you trouble down the road, if you can change the customer
of an order), in
Anthony W. Youngman wrote:
In article <[EMAIL PROTECTED]>, Lauri Pietarinen
<[EMAIL PROTECTED]> writes
So in your opinion, is the problem
1) SQL is so hard that the average programmer will not know how to use it
efficiently
Nope
or
2) Relational (or SQL-) DBMS'es
Anthony W. Youngman wrote:
In article <[EMAIL PROTECTED]>, Lauri Pietarinen
<[EMAIL PROTECTED]> writes
Anthony W. Youngman wrote:
Fine. But MV *doesn't* *need* much of a cache. Let's assume both SQL and
MV have the same amount of RAM to cache in - i.e. *not* *muc
I suggest using
the customer-order-order_detail-product database
If 1) I would like to hear some concrete examples.
best regards,
Lauri Pietarinen
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
a RDBMS
Aw, that's unfortunate. It took me a while to get working.
It is infact an integrated application development environment where
you can define a great part of your application in a declarative
fashion.
regards,
Lauri Pietarinen
---(end of broadcast)
y easy mapping to do and you have to resort
to all sorts of unclean stuff to make it work...
regards,
Lauri Pietarinen
---(end of broadcast)---
TIP 8: explain analyze is your friend
11 matches
Mail list logo
