Hi.
On Tue, Aug 14, 2001 at 10:41:16PM +0930, [EMAIL PROTECTED] wrote:
> Hi Heitzso,
>
> Thanks for your suggestion, and in the absence of feedback from anybody else
> I suspect you're probably right. The system this thing is running on is a
> vastly outdated P150 with 128MB.
With 128MB, you t
al Message -
From: "Heitzso" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 3:03 AM
Subject: Re: SELECT MIN(field) takes minutes on a large table!
> I apologize in advance for jumping in with a hardware suggestion,
> but I just joined the l
I apologize in advance for jumping in with a hardware suggestion,
but I just joined the list to sort out some similar questions.
Our production sql server (Microsoft's) is sitting on a box
that's now outdated w/ 2 200mhz processors and maybe .5G
of RAM. A query that takes 30 seconds on that box
Dan Makovec wrote:
>
> Hi folks,
>
> Wondering if anybody can help me with this one.
>
> I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit
>with it. It's a basic table storing stock trading prices:
>
> ++-+--+-++--
> I've put an index on date and symbol combined,
> and tried putting one on just date.
Did you then do an "EXPLAIN ..." before your query
to see the results?
> select min(date) from stockmarket where symbol='abc'
explain select min(date) from stockmarket ...
That will tell you if your indexe
Hi folks,
Wondering if anybody can help me with this one.
I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit
with it. It's a basic table storing stock trading prices:
++-+--+-++---+
| Field | Type| Null | Ke
