in reply to Re^2: Which is quicker - writing to a file or inserting into a db?
in thread Which is quicker - writing to a file or inserting into a db?

There's no performance penalty in appending to a large file.

But you should probably think about locking, as multiple processes simultaneously writing to the same file may cause problems. Or just make sure that each process writes to its own file, e.g. by appending $$ to the file name.

  • Comment on Re^3: Which is quicker - writing to a file or inserting into a db?