would
cause some VERY weird join results, and may be your problem. Try adding in
the join clause in the where clause.
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 2:52 PM
Subject: RE: Help needed with
Okay, here is the full monty from the database regarding the query in
question, any suggestions on how to improve any of it are greatly
appreciated!
Also, if any more info is needed, just let me know.
Thanks!
Bryan
QUERY:
mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
Please do a "SHOW FIELDS FROM" and "SHOW KEYS FROM" on all tables involved
so we can see what's going on here. Also, a warning, if desacription is
indexed, by doing LIKE '%GABA%' with wildcard at beginning, it won't use
index's.
Would also help if you did an EXPLAIN on that query and sent that.
hi.
by skimming that query, the first thing that will take a long time is the
'description like "%GABA%"' part...that's a pretty inefficient method of
searching due to the wildcard at the beginning of the string.
if there are no indexes on the tables, you should probably add some.
"show index fr
