User logging...

I'm about to add logging features into my webapplication which is basically querying database and keyword indexes. I will maintain user logs associated to user profiles. I was wondering what the best way would be to store the logs. Currently these are stored in XML files but I presume a database solution is better? How are user profiles and logs maintained usually? Amazon and many other big shopping sites must have implemented some very efficient method I guess, any one can shed light on this or talk about what architecture you implemented and what decisions you took...

Hi ravish007, welcome to the forums,
Since you have access to a database I would probably log to a table preferably in another database (security precaution) if I were you.
It depends on what and how much you're logging, what, how and how often you plan on using it, and what you're preferences are.
Writing to log files is OK as long as you can depend on the permissions allowing it. (same can be said about db server reliability I guess). Or you could even email them to yourself if you just wanted to know about stuff right away.