Log Files

[Nate1]

I have two Log tables one for Errors raised on exceptions and another for general stuff like User logged in, user Logged out.

Question is too what Level should I Log, for Example:

Create a Listing involves,
Logging in
recording the listing + images + Categories (Ass table)

Should I record each "Transaction"? or Say just the Listing Created?
this may not sound like much but If I do this for each process registration updates deletes ... could be heaps

The tables going to get big either way, I'm trying to build a service that will check if a listing closes on a specific date, if I used a similar process to empty log records that are a month old is this OK?

[ray326]

The fact someone logged in or out is trivial and shouldn't need to be logged. The create/update/delete of a listing is important. If you need change history then a listing record should never be deleted. When someone updates a listing the "current" version should be marked as old and a new record with the updated data inserted.

[Nate1]

I see your point about logins I should only ever record failed login attempts,

I don't think the duplication for updated records would suit my requirements.