in reply to Re: Database setup for daily db
in thread Database setup for daily db

tachyon,

This is indeed a nice solution, but I don't see a reason to create a new table for each day.

Isn't this what relational databases are for. I just would the data in one or more tables with the date stamp as Primary Key.
This way, when you want to retrieve the data from a specific day, you only need one query, instead of fetching first the table name, and than doing the actual query on this table.
At least, that is my honest opinion.
---------------------------
Dr. Mark Ceulemans
Senior Consultant
IT Masters, Belgium