Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Ask HN: How do you log application events?.
That's what I would do.
> However, after three and a half years of continued use, the table is now way too large.
Yeah, that's what happens...
There are many ways to handle this issue. The simplest is to start archiving your records ( i.e. dumping your old records into archival tables ).
Do you have access to a DBA or a data team? They should be able to help you out with this if you have special requirements.
There are no comments on this comment yet.
That's what I would do.
> However, after three and a half years of continued use, the table is now way too large.
Yeah, that's what happens...
There are many ways to handle this issue. The simplest is to start archiving your records ( i.e. dumping your old records into archival tables ).
Do you have access to a DBA or a data team? They should be able to help you out with this if you have special requirements.