Large amounts of text - mysql or flatfile?

Question

I am writing a web application in PHP that will store large numbers of blocks of arbitrary length text. Is MySQL well suited for this task with a longtext field or similar, or should I store each block of text in its own file and use a MySQL table for indexes and filenames? Think online bulletin board type stuff, like how you would store each users posts.

Answer 1

Yes, MySQL is the way to go. A flat file would take much longer to search etc.

Mysql all the way. Much more efficient.