4 ms·
Altering the logging table scheme once it reaches several million rows? Not fun. I think flat files are much easier to scale.
by koko775 14y ago
Altering the logging table scheme once it reaches several million rows? Not fun. I think flat files are much easier to scale.
- sukuriant 14y agoYou could create a new table called Logs2 and use your database's union functionality when querying it. Perhaps even a view to make things a whole lot easier.
- Yeroc 14y agoIf you're talking about Postgres most people would likely implement this using date/time-based partitioning which provides a more seamless solution to this problem.
- jsprinkles 14y agoMongoDB capped collections. Solved.
- jacques_chester 14y agoMost serious RDBMSes can handle online DDL without locking the table.