Ok so I'm going to try something like a wall but it's not a wall.
It's a chat box that also adds certain activities to it as well.
So peoples chat will come up and some times "so and so has done this"
My question is what would be the best way to store this data?
If I do it in one table it'll get quite bulky but I could do a cron every few hours that deletes chat entries older than said datetime
Or would it be better to have 2 seperate tables one for chat one for activity?
Then I'd have to do a bit more coding but would this way be more efficient?
Any thoughts on this would be most appreciated