Large amount of text - mysql or flatfile?

Question

I am writing a web application in PHP that will store a large number of blocks of text of arbitrary length. Is MySQL well suited for this task with a longtext field or similar, or should I store each block of text in my own file and use a MySQL table for indexes and file names? Think about how you will store each user's posts.

Answer 1

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

Mysql completely. Much more effective.