Hi,

Im setting up some error logging to record PayPal transaction details and Im just wondering if it would be better to store the log in a database or a txt file? I think a txt file would be slighty quicker as it wouldnt have to connect to the database, is this correct?

whats good practice if I store it in a txt file? should I store it in one big txt file or should I have the script create new txt files everytime the log file reachs a certain size say 100K? Should I only keep a log for a few months or do you normally keep a log for the entire life of a site?

Thanks

I would use a .txt file and give the filename something like: paypal_error_log_2010_03.txt

You check to see if the file is already made for the year and month, if not, create it,
if it exists, append to it.

Filename is descriptive, so you know by viewing directory what the file contains.

Thanks, that seems a sensible way to do it and seems to work nicely