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.