List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 26 2000 8:49am
Subject:Re: very slow query
View as plain text  
In the last episode (Nov 26), Brittingham, John said:
> Thanks Rob  I'll give that a try. Here the create statments for the
> tables

Field names don't matter at all when doing joins.  Field widths, on the
other hand, do.  New_user_list.user_name and NWRS_log_data.uname should
both be 15 chars, probably.  If that doesn't help, post the output of
"EXPLAIN SELECT ..." on your query.

-- 
	Dan Nelson
	dnelson@stripped
Thread
very slow queryJohn Brittingham23 Nov
RE: very slow queryJohn Brittingham26 Nov
  • Re: very slow queryDan Nelson26 Nov