Welcome Guest, Not a member yet? Register   Sign In
Store hundreds of tasks per day per user in custom log sub-system
#5

[eluser]jonez[/eluser]
If you anticipate this table growing to over 1m records you should create two copies of your tables and use a CRON job to move old data into the archives. This will keep your current data queries fast and allow you to do historical reporting (users understand these taking longer).


Messages In This Thread
Store hundreds of tasks per day per user in custom log sub-system - by El Forum - 08-15-2014, 09:35 AM



Theme © iAndrew 2016 - Forum software by © MyBB