Database design, which is better

2004-01-26 Thread Alex croes
I have an question about the design of a database. What is the best way to design tables. Is it better to create many small tables, or create fewer big tables. Which of those two options will get the best performance? TIA, Alex Croes -- MySQL General Mailing List For list archives:

Re: Database design, which is better

2004-01-26 Thread Jochem van Dieten
Alex croes said: I have an question about the design of a database. What is the best way to design tables. Is it better to create many small tables, or create fewer big tables. Which of those two options will get the best performance? Don't worry about performance. If performance is really

Re: Database design, which is better

2004-01-26 Thread Mike
I have an question about the design of a database. What is the best way to design tables. Is it better to create many small tables, or create fewer big tables. Which of those two options will get the best performance? If you are asking whether to store the data all in one big table or a bunch