RE: To split or not to split columns

2005-07-08 Thread Thomas Sundberg
-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

Re: To split or not to split columns

2005-07-08 Thread Brent Baisley
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