Re: Another newbie question
Posted by:
Rick James
Date: February 12, 2014 10:47PM
The table is bulkier than necessary, hence probably more disk I/O, hence slower.
CHAR(15) takes 15 bytes on disk.
VARCHAR(15) takes 1 to 16 bytes (length + characters); this is usually preferable.
Please provide the EXPLAIN.
How many rows are there for a typical ClientID? For '20005881'?
I think LEFT JOIN will be the solution.
This change might help:
KEY `fk_QSO_User_idx` (`clientID`), -->
INDEX(clientID, DXCC, band)
Subject
Written By
Posted
February 06, 2014 11:58PM
February 07, 2014 01:11AM
February 07, 2014 06:41AM
February 07, 2014 11:15AM
February 07, 2014 07:50PM
February 08, 2014 11:54AM
February 08, 2014 05:41PM
February 08, 2014 06:55PM
February 08, 2014 06:59PM
February 08, 2014 08:48PM
February 09, 2014 02:56AM
February 09, 2014 07:43PM
February 10, 2014 02:31PM
February 11, 2014 05:10AM
February 11, 2014 10:41AM
February 11, 2014 08:12PM
February 12, 2014 12:50AM
February 12, 2014 08:32AM
February 12, 2014 07:39PM
Re: Another newbie question
February 12, 2014 10:47PM
February 12, 2014 11:50PM
February 13, 2014 12:00AM
February 13, 2014 02:14AM
February 13, 2014 11:10PM
February 16, 2014 12:51AM
February 27, 2014 04:54AM
February 27, 2014 08:47PM