[Solved] Show data from multiple tables by date and time [closed]

Question

Yes it is, like “Tom asked a question:__ in:__ few minutes a go”

So you need a user name, an action, a timestamp and a hidden id.

Well performance-wise a separate table is better (you avoid unions and maybe joins if it’s not necessary to be mormalized), but you have the extra storage (is this an issue?) and the overhead of inserting new records to this table (tiny). Be aware for the usage of a switch to get the details of each activity from its origin table.

Bottom line everything depends on the data volume and the traffic.

Accepted Answer

Yes it is, like “Tom asked a question:__ in:__ few minutes a go”

So you need a user name, an action, a timestamp and a hidden id.

Well performance-wise a separate table is better (you avoid unions and maybe joins if it’s not necessary to be mormalized), but you have the extra storage (is this an issue?) and the overhead of inserting new records to this table (tiny). Be aware for the usage of a switch to get the details of each activity from its origin table.

Bottom line everything depends on the data volume and the traffic.