Thank you Dan,
I will try that.
Mikhail Berman
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 5:29 PM
To: Mikhail Berman
Cc: Chris White; mysql@lists.mysql.com
Subject: Re: Q2. Is there anything could be done to speed up this query
In the
In the last episode (May 03), Mikhail Berman said:
> Thank you, Chris
>
> But the table is indexed on the field you are referring to and the other
> one the query, which is evident from this:
>
> > KEY `prdadadx` (`price_data_date`),
> > KEY `prdatidx` (`price_data_ticker`)
These are two se
8902 May 1 09:00
TICKER_HISTORY_PRICE_DATA_STAGING_NO_KEYS.frm
Any other ideas, please?
Mikhail Berman
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 3:27 PM
To: mysql@lists.mysql.com
Subject: Re: Q2. Is there anything could be done to speed up this query
On Wednesday
On Wednesday 03 May 2006 12:16 pm, Mikhail Berman wrote:
> I have a table:
>
> CREATE TABLE `TICKER_HISTORY_PRICE_DATA_STAGING_NO_KEYS` (
> `price_data_ticker` char(8) NOT NULL default '',
> `price_data_date` date NOT NULL default '-00-00',
> `price_data_open` float default NULL,
> `pri
Dear List,
I have a table:
CREATE TABLE `TICKER_HISTORY_PRICE_DATA_STAGING_NO_KEYS` (
`price_data_ticker` char(8) NOT NULL default '',
`price_data_date` date NOT NULL default '-00-00',
`price_data_open` float default NULL,
`price_data_high` float default NULL,
`price_data_low`
