RE: MySQL Database Questions

2002-05-11 Thread Roger Baklund
* [EMAIL PROTECTED] > 1. Is it a good idea to have all the columns in one big table ? This will depend on the nature of your data. You say you have many varchar columns. If many of them contains the same value, you could get substantial speed/space improvements by splitting (normalizing) the tabl

MySQL Database Questions

2002-05-11 Thread Florian Wilken
Dear Mr. Jeremy D. Zawodny, I am subscriber of the mysql.com MailingList and have received some of your mails. From the mails I get the idea that you have quite some experience with mysql. We are planning to migrate our database (currently oracle) to mysql. Our database consists of about 150