March 14, 2011 at 7:12 pm
I am in search of knowledge... For Logging .....what is the best option among Text FIle or SQL table, can anyone give me a detail knowledge plz
March 14, 2011 at 7:30 pm
If it's in a table, you can more easily select from the logs and log details to perform additional administration. Notifications or whatever. This solution can give you more flexibility [perhaps later] over a text file.
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
March 15, 2011 at 1:07 am
There is no right or wrong answer on this one.
SQL --> easy to search for something specific using queries and useful to build reports on
Flat file --> better write performance, especially if you log a lot.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply