create table daily to store the log reports in Database
Our project, we are开发者_如何学Python tracking the log reports for each day, now we are writing data to a files which has all the records
we are now storing the data to database,
My Question is we are planned to create table daily to store the log reports. Is this a correct Process
Create a single table to store your log entries. Modern databases can handle millions (or even billions) of rows in a single table without any issue.
This will allow you to do analysis on any of your log entries using a single set of queries. You won't have to write different queries (or use dynamic SQL) to read from each different days' entries.
精彩评论