Arty Ziff Posted September 29, 2016 Share Posted September 29, 2016 Each record has a fairly large block of text. Should I store the text block as a file and not in the DB? Quote Link to comment https://forums.phpfreaks.com/topic/302254-table-row-with-text-block/ Share on other sites More sharing options...
Zane Posted September 29, 2016 Share Posted September 29, 2016 Is, uh... Is that all you got? Each record of what? Care to elaborate quite a bit more? Quote Link to comment https://forums.phpfreaks.com/topic/302254-table-row-with-text-block/#findComment-1537885 Share on other sites More sharing options...
Arty Ziff Posted September 29, 2016 Author Share Posted September 29, 2016 Simple question: A row of data, one column of which is a large block of text. To store the text in the DB directly, or associate the row with a file that contains the text Quote Link to comment https://forums.phpfreaks.com/topic/302254-table-row-with-text-block/#findComment-1537888 Share on other sites More sharing options...
kicken Posted September 29, 2016 Share Posted September 29, 2016 How large is large? If you're talking a few MB or less I'd just keep it in the database. Keep things simple and not have to mess around with keeping external files in sync. If you're using a TEXT type for the column then mysql will store it outside the primary data area so having a bunch of text in the database shouldn't affect performance much. Mysql won't be trying to access it unless you specifically request it. If you're getting into the hundreds of MB or larger then it may be worth moving it out to a separate storage location to keep the overall DB size down so you can backup the database quicker and easier. Quote Link to comment https://forums.phpfreaks.com/topic/302254-table-row-with-text-block/#findComment-1537889 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.