MySQL Forums
Forum List  »  Newbie

Re: Another newbie question
Posted by: Marc Hillman
Date: February 12, 2014 11:50PM

Thanks for the great suggestions.

I have converted 2 CHAR columns to VARCHAR and storage has gone from 34,905 to 29,679, so it's a wothwhile improvement.

EXPLAIN is below, although it seems to contain the same information as the CREATE TABLE command.

There are typically 1,000 to 20,000 rows for each client id. Max is 60,000. Total record count is 400,000.

I will try the INDEX change, but it will take me a little time.

Thanks heaps for the suggestions.

ield 	Type 	Null 	Key 	Default 	Extra
clientID 	int(11)	NO 	PRI 	NULL	
STATION_CALLSIGN 	varchar(15)	NO 		NULL	
CALLSIGN 	varchar(15)	NO 	PRI 	NULL	
QSO_DATE 	date	NO 	PRI 	NULL	
TIME_ON 	time	NO 	PRI 	NULL	
BAND 	enum('2190m','560m','160m','80m','60m','40m','30m'...	NO 	PRI 	NULL	
MODE 	enum('AM','AMTORFEC','ASCI','ATV','CHIP64','CHIP12...	NO 	PRI 	NULL	
DXCC 	smallint(6)	NO 		NULL	
RST_SENT 	char(4)	YES 		NULL	
GRIDSQUARE 	char(4)	YES 		NULL	
FLAGS 	set('QSL_RCVD','EQSL_QSL_RCVD','LOTW_QSL_RCVD','QS...	YES 		NULL	
Checker1 	int(11)	YES 		NULL	
Checker2 	int(11)	YES 		NULL	

Options: ReplyQuote


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
February 12, 2014 10:47PM
Re: Another newbie question
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


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.