Implications of storing data in MySQL database or as files?
Hello again,
Sorry if this isn't allowed, I wasn't sure which other community to ask.
I have a story archive, and the options are to store the stories in the database, or as a .txt file.
I can choose either storage method, that is I have no restriction which forces me to use one or the other. Ideally, I would prefer to use the database, mainly apparently "that's what they're made for", but I was wondering why shouldn't I use the database? The story data would be a minimum of around 1000 words per entry, I guess. I heard 16,000 is around the maximum for database entries (I'm assuming TEXT) so 1000-16,000 words?
The only reason I can think of is:
(a) The database gets so big, creating back-ups aren't viable. (But I'm not sure whether this is true.)
(b) Database performance might slow down. (How big would it have to be for this to happen?)
Insight into this would help very much, thanks!
In addition, which would you rather store in? The database or using text files?
Sorry if this isn't allowed, I wasn't sure which other community to ask.
I have a story archive, and the options are to store the stories in the database, or as a .txt file.
I can choose either storage method, that is I have no restriction which forces me to use one or the other. Ideally, I would prefer to use the database, mainly apparently "that's what they're made for", but I was wondering why shouldn't I use the database? The story data would be a minimum of around 1000 words per entry, I guess. I heard 16,000 is around the maximum for database entries (I'm assuming TEXT) so 1000-16,000 words?
The only reason I can think of is:
(a) The database gets so big, creating back-ups aren't viable. (But I'm not sure whether this is true.)
(b) Database performance might slow down. (How big would it have to be for this to happen?)
Insight into this would help very much, thanks!
In addition, which would you rather store in? The database or using text files?
