Re: Is there a SWITCH equivalent in MySQL?

[Rick James]

First, let's make sure PARTITION will do anything useful for you. (Too many people jump into PARTITION, only to find that it does not really help in performance.) Please provide more information:
* SHOW CREATE TABLE (without partitions) -- The indexes are vital to performance of rapid inserts;
* State what kind of PARTITION ON you are thinking of;
* You say lots of inserts -- how _fast_ will the inserts come (rows per second);
* Can you "batch" the INSERTs? (multi-row INSERT or LOAD DATA)
* What are the SELECTs like?
* Is this a 'time series'? That is, will you be purging 'old' data?

DATE is a datatype that takes 3 bytes. INT takes 4.

Q1: Each partition has the same INDEXes.
Q2: Check the latest MySQL 5.5 version. (I don't know the answer.)