开发者

Plain text vs Database Storage

开发者 https://www.devze.com 2023-01-10 07:19 出处:网络
I need to store a large string that represents music notation in text format. This string could be anywhere between a few lines to several hundred.

I need to store a large string that represents music notation in text format. This string could be anywhere between a few lines to several hundred.

I need to store meta data about the string (eg artist, instrument etc) in a database.

I'm wondering, would it be better to store the large text string in a flat file or in the database?开发者_高级运维

I think if I store it in the database it might be easier to monitor concurrency issues etc... but then in a flat file it would be easier to scale.


If you're already storing the metadata about the music in a database, then just store the string representation alongside it.

That way all your information is in a single place and you won't have to worry about retrieving data from two locations when a user wants to fetch it.

0

精彩评论

暂无评论...
验证码 换一张
取 消