Skip to main content
Participant
July 15, 2006
Question

Database/Forum Storage

  • July 15, 2006
  • 1 reply
  • 235 views
My question is what would be the best way with CodeFusion performance wise to store several million paragraph size of text? Would it be sufficent to store each of the text in a data base. Or perhaps store the file link in the database and then pull up the information from text files. What would be the best way to go about that. Basically storage for text in a forum like situation where users might request the text perhaps hundreds of time per minute.
This topic has been closed for replies.

1 reply

July 17, 2006
If the text changes rarely and doesn't have to be edited by web users and doesn't need to be restricted by anything more than basic authentication, then leave it in a file and just link to it.

Otherwise, use a database. For that much text, do not use MS Access though.