>> On 8/31/06, Harrison Fisk ** <[EMAIL PROTECTED]> *** wrote:
>> Hello,
>>
>> On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote:
>>
>>> Hey list;
>>>
>>> I posted this message under an earlier thread which touched the same
>>> subject - but I realized my case could be slightly different,
On 8/31/06, Harrison Fisk <[EMAIL PROTECTED]> wrote:
Hello,
On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote:
> Hey list;
>
> I posted this message under an earlier thread which touched the same
> subject - but I realized my case could be slightly different, thus
> posting a new thread here.
Hello,
On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote:
Hey list;
I posted this message under an earlier thread which touched the same
subject - but I realized my case could be slightly different, thus
posting a new thread here. Sorry for any inconvenience.
I have two tables, one of which
Kim,
The first thing I'd do is run a MyISAMChk on the table to see if the index
is damaged. The second thing I'd do is run Optimize on the tables regularly
because after a lot of rows have been deleted it leaves holes in the table
which slows down table performance.
Of course you can
On 8/31/06, Brent Baisley <[EMAIL PROTECTED]> wrote:
hmmm, not sure why it's only scanning 89K records from the products table, I
would think it would scan the whole table. It is
scanning the entire items table, which I would think it wouldn't do.
Well, the query in question actually did do so
emory settings?
SHOW VARIABLES LIKE "%buffer_size"
- Original Message -
From: "Kim Christensen" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Thursday, August 31, 2006 9:12 AM
Subject: Re: Insane execution time for JOIN query
On 8/31/06, Brent Baisley <
hanged from default.
- Original Message -
From: "Kim Christensen" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Thursday, August 31, 2006 5:12 AM
Subject: Insane execution time for JOIN query
> Hey list;
>
> I posted this message under an earlier thread
: "Kim Christensen" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Thursday, August 31, 2006 5:12 AM
Subject: Insane execution time for JOIN query
Hey list;
I posted this message under an earlier thread which touched the same
subject - but I realized my case could be slightly
Hey list;
I posted this message under an earlier thread which touched the same
subject - but I realized my case could be slightly different, thus
posting a new thread here. Sorry for any inconvenience.
I have two tables, one of which is a list over products which all have
unique product id's (pr
