TECTED]
Subject: Severe performace problem linking tables with mysql
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table
type)
I have discovered a performace issue when joining several tables
together.
The performance is extremely poor when performing select queries using
the
W
22.61 sec)
From: Benjamin Pflugmann <[EMAIL PROTECTED]>
To: Joseph Dietz <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Severe performace problem linking tables with mysql
Date: Wed, 18 Dec 2002 22:22:00 +0100
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wr
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wrote:
>
> PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
>
> I have discovered a performace issue when joining several tables together.
> The performance is extremely poor when performing select queries us
Joseph Dietz wrote:
MediasMediaAuthorsAuthors
pk_media_id fk_media_id, fk_author_id pk_author_id
In your table definition, is there an index on each of your keys shown
above? What kind of performance 'degredation'? How many values are you
chec
change to make it quicker.
-Original Message-
From: Joseph Dietz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Severe performace problem linking tables with
mysql
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
I have discovered a performace issue when joining several tables together.
The performance is extremely poor when performing select queries using the
WHERE clause and joining the tables with the pk_media_id = fk_media_
