In terms of read performance, you won't see much difference splitting
them up within the same table. What will degrade the write performance
is adding of additional indexes since they will need to be updated on
every write. Indexing will obviously speed up search performance
(~read).
I think
> -Original Message-
> From: Mathias [mailto:[EMAIL PROTECTED]
> Sent: den 8 juli 2005 11:50
> To: mysql@lists.mysql.com
> Subject: To split or not to split columns
>
> I have an index char column in the format -bb-cc-dd
>
> where a,b,c and d are inte
I have an index char column in the format
-bb-cc-dd
where a,b,c and d are integers
Most of the time, the whole column will be searched for. But it will
sometimes be necessary to search for the substring in b or d (or a
combination of both) Thus if I split them up, they will need to be
