I'd think to make a new table (logs_table) and track the activity there. So the only query I'd have to run is something like:
SELECT * FROM logs_table
and I'll be ok. Is there a more efficient way of doing this?
Thanks in advance :)
I'd think to make a new table (logs_table) and track the activity there. So the only query I'd have to run is something like:
SELECT * FROM logs_table
and I'll be ok. Is there a more efficient way of doing this?
Thanks in advance :)
Not really, best shot is to save data in DB, however I'd be careful with the structure and the age of records before you delete them, so you don't overload the DB and slow down the site.