Barney is definately right about the db is going to be more resource intensive than writing to a file. To me it would come down to how much data you are going to be logging and for how long. Basically, are you going to just be glancing at a log file every once in a while and scrolling through it, or are you going to need the ability to query it. Is it informational only, or is it auditing processes. Is it importaint to the project or is it just helpful?
On 9/20/05, Barney Boisvert <[EMAIL PROTECTED]> wrote: > If you want to log query actions, then a trigger is the best, since > it'll be pretty much error proof if set up properly. If you want to > log business operations, then the DB/log4j distinction becomes a > matter of how you want to use the data. Obviously having the log data > in a DB facilitates easy report extraction (you just query the > table(s)). On the flip side, logging to the DB is very likely going > to be more resource intensive than logging to a file. > > cheers, > barneyb > > On 9/20/05, Michel Deloux <[EMAIL PROTECTED]> wrote: > > Hi all > > > > what's the best choice to store users actions in a CF > > application(inserts, updates and deletes)? DB or Log4J could be > > resolve this? Anyone use log4j? Any approaches? > > > > Cheers > > > > MD > > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218713 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
