>> Of the data? Or of the queries?
> Not the data. Just your query, the output from explain and a create
> table statement.
Query:
SELECT DISTINCT cards_crypt.*
FROM user_haves, cards_crypt WHERE
cards_crypt.name LIKE "%harrod%" AND
user_haves.card_name = cards_crypt.name AND
user_haves.total_have > 0 AND
user_haves.user != "joe_bob_briggs"
Explain:
*************************** 1. row ***************************
table: user_haves
type: ALL
possible_keys: card_name,total_have
key: NULL
key_len: NULL
ref: NULL
rows: 79370
Extra: where used; Using temporary
*************************** 2. row ***************************
table: cards_crypt
type: eq_ref
possible_keys: name
key: name
key_len: 255
ref: user_haves.card_name
rows: 1
Extra: where used
2 rows in set (0.00 sec)
Create Table data:
CREATE TABLE user_haves (
card_name varchar(100) NOT NULL default '',
total_have int(11) unsigned NOT NULL default '0',
user varchar(50) NOT NULL default '',
available int(11) unsigned NOT NULL default '0',
record_num int(11) unsigned NOT NULL auto_increment,
PRIMARY KEY (record_num),
KEY user (user),
KEY card_name (card_name),
KEY total_have (total_have),
KEY available (available)
) TYPE=ISAM PACK_KEYS=1;
CREATE TABLE cards_crypt (
record_num int(11) unsigned NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
clan varchar(100) NOT NULL default '',
capacity int(10) NOT NULL default '0',
disciplines varchar(100) default '',
superior varchar(100) default '',
inferior varchar(100) default '',
title varchar(100) default '',
bonus_penalty text,
release_set varchar(100) NOT NULL default '',
rarity varchar(50) default '',
artist varchar(100) default '',
have int(10) default '0',
need int(10) default '0',
notes text,
alternate_name varchar(255) default '',
card_monger_url varchar(255) default '',
PRIMARY KEY (record_num),
UNIQUE KEY name (name),
KEY clan (clan),
KEY capacity (capacity),
KEY release_set (release_set)
) TYPE=ISAM PACK_KEYS=1;
If you need any more information to provide assistance, please
let me know and I'll post it.
Chris
MySQL
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
