Most efficient way of displaying latest user activity in your site? PHP/MySQL

I'd think to make a new table (logs_table) and track the activity there. So the onl开发者_Python百科y 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.