I think I'll throw in the towel. Here is the slow performance I'm getting
when joining 13 tables. The query simply takes too long.
J
explain SELECT distinct Medias.pk_media_id, Organisms.common_name,
Tissues.type As tiss_type, Cells.type As cell_type,
Organelles.type As org_type, Macrom
platform: windows 2000 pro, mysql default table type myIsam, non-binary
distribution (install version).
I am still getting very slow query results when I join multiple tables
together. I have been trying to figure this out for days and am at a loss. I
added an index to my cross reference table
Someone helped me solve the problem with my slow query results!
I was missing the index which I should have added to my cross reference
tables.. AND I should have used the INNER JOIN clause instead of joining my
table with the WHERE clause. In the future I will be far more careful
designing my q
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
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_
