Joseph D wrote:
Is it possible for you to tell me where I should add my indexes? I
have read the manual but can't figure out where I must add them to my
tables.
If you have lots of disk space, add them to every column that is in your
query(ies). Then see what the EXPLAIN output says, and de
Joseph Dietz wrote:
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.
Did you E-mail the MySQL staff to ask how much it would cost to have
them look at this problem? Or perhaps one of the other paid consultants
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
