Rough calculation is;
Field sizes
4 `id` int(11) NOT NULL,
18+1 `username` varchar(18) NOT NULL default '',
20+1 `nickname` varchar(20) NOT NULL default '',
32+1 `password` varchar(32) NOT NULL default '',
1 `sex` char(1) NOT NULL default '',
3 `rdate` date NOT NULL default '0000-00-00',
3 `rtime` time NOT NULL default '00:00:00',
30+1 `securecode` varchar(32) NOT NULL default '',
1 `vis` tinyint(1) NOT NULL default '0',
8 `logdate` datetime NOT NULL default '0000-00-00 00:00:00',
=124 + 16 = 140 bytes per data row
PK = 4 + 25 = 29 bytes per row
Key1 = 18 + 10 = 28 bytes per row
Key2 = 20 + 10 = 30 bytes per row
Total 227 bytes per row x 5,000,000 = 1.13 Gb
This message contains information that may be privileged or confidential and is the
property of the Capgemini Group. It is intended only for the person to whom it is
addressed. If you are not the intended recipient, you are not authorized to read, print,
retain, copy, disseminate, distribute, or use this message or any part thereof. If you
receive this message in error, please notify the sender immediately and delete all
copies of this message.
