Hi
I am doing some testing with ICE (vs partitioned table in MySQL) and have just done an upload.
File size: 5.3GB
Row count: 34329032
Time taken : 1030 seconds
CREATE TABLE `from_table` (
`uid` varbinary(20) NOT NULL,
`date` datetime NOT NULL,
`email` char(255) NOT NULL,
`userid` char(255) NOT NULL,
`subject` char(255) NOT NULL,
`bytes` int(11) NOT NULL
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=ascii
Running on 64-bit Fedora 9 with two dual-cores (XEON), 12GB RAM
How does that look to the experts? I notice it wasn’t doing any threading across multiple cores. Should I expect it to?
Anything I should do to tune/check the hardware/disks? Or does these figures look ok already?
The MySQL test is still running 
I will update when it finishes, hah. There are indexes on the table and that is what I think is killing the time
Thanks
