Dear Professional.

I want to capture login activity of client [trading clients].

I have following events for now.

Login
Logout
Secret password changed.
Place order
Modify order

The above events would be grow very frequently, is there any better approach
to deal which these kind of scanario for instance.

When I deal with Login event, I have to caputer UserID, Login Date, Login
Time.

When I deal with Secret Password Modification even, I have to capture
UserID, Secret Password Before, Secret Password After.

So the problem here is against each event I have different columns, I was
thinking I can comeup with one generic table that has XML approach but every
day I am expecting 100000 records.

Table 1:
Events
EventID
Event

Table 2
Audit Log
LogID
EventID (reference from event table)
Audit (XML data)
UserID
......

Any idea? or any better approach to deal with this scanario?

Thanks