Good of One vs. Good of Many

Top Pagina
Bijlagen:
Bericht als e-mail
+ (text/plain)
Delete this message
Reply to this message
Auteur: KJZZ Webmaster
Datum:  
Onderwerp: Good of One vs. Good of Many
I am working on an application using MySQL where about 100 records will
be entered into a table every day.

Is it a good idea to create separate tables with the date as the title of=

each table? Or would it be better to have a date field and add all recor=
ds
to a single table?

I would think that creating many tables would add to the speed of the app=
lication.
However wouldn't this lead to difficulty in searching the tables, or is
there a sql statment for searching across many tables?

I may post this on the MySQL list as well, but I thought I would start he=
re
first.

Thanks in advance for your help.

John T.