in reply to Re: Database setup for daily db
in thread Database setup for daily db
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
|
|---|