-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 integers
You want to normalize your
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