3 ms·
> We are currently inserting our logs in an sql database, with timestamp, logType, userId, userAgent and description columns. That's what I would do. > Howeve
by fasfawefaw 11y ago
> We are currently inserting our logs in an sql database, with timestamp, logType, userId, userAgent and description columns.
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.