--- Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Nov 9, 2007 11:47 AM, Ted Byers
> <[EMAIL PROTECTED]> wrote:
> >
> > --- Tom Lane <[EMAIL PROTECTED]> wrote:
> >
> > > Ted Byers <[EMAIL PROTECTED]> writes:
> [snip]
> Which is better depends largely on how your database
> is built. MySQL
> stil
On Nov 9, 2007 11:47 AM, Ted Byers <[EMAIL PROTECTED]> wrote:
>
> --- Tom Lane <[EMAIL PROTECTED]> wrote:
>
> > Ted Byers <[EMAIL PROTECTED]> writes:
> > > OK, it is challenging to present it in plain text,
> > but
> > > here is the HTML exported by MySQL Query Browser.
> >
> > Why are you asking t
Ted Byers <[EMAIL PROTECTED]> writes:
> --- Tom Lane <[EMAIL PROTECTED]> wrote:
>> Why are you asking this list for help with a MySQL
>> performance problem?
>>
> because my question isn't really about MySQL, but
> rather about how best to construct the SQL required to
> get the job done, regardle
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Ted Byers <[EMAIL PROTECTED]> writes:
> > OK, it is challenging to present it in plain text,
> but
> > here is the HTML exported by MySQL Query Browser.
>
> Why are you asking this list for help with a MySQL
> performance problem?
>
because my question
Ted Byers <[EMAIL PROTECTED]> writes:
> OK, it is challenging to present it in plain text, but
> here is the HTML exported by MySQL Query Browser.
Why are you asking this list for help with a MySQL performance problem?
regards, tom lane
---(end of
Ted Byers wrote:
--- Gregory Stark <[EMAIL PROTECTED]> wrote:
I think you'll have to post the actual explain
analyze output you're getting
and the precise schema you have.
OK, it is challenging to present it in plain text, but
here is the HTML exported by MySQL Query Browser. If
you cut bet
--- Gregory Stark <[EMAIL PROTECTED]> wrote:
> "Ted Byers" <[EMAIL PROTECTED]> writes:
>
> > As a prelude to where I really want to go, please
> > consider the following SELECT statement.
> >
> > SELECT close_price FROM stockprices A
> > WHERE price_date =
> > (SELECT MAX(price_date) FR
"Ted Byers" <[EMAIL PROTECTED]> writes:
> As a prelude to where I really want to go, please
> consider the following SELECT statement.
>
> SELECT close_price FROM stockprices A
> WHERE price_date =
> (SELECT MAX(price_date) FROM stockprices B
> WHERE A.stock_id = B.stock_id AND A.st
As a prelude to where I really want to go, please
consider the following SELECT statement.
SELECT close_price FROM stockprices A
WHERE price_date =
(SELECT MAX(price_date) FROM stockprices B
WHERE A.stock_id = B.stock_id AND A.stock_id =
id);
stockprices has a primary key comprised
