> We have a database that uses MS SQL text fields. Is this > what the CLOB in > CF is for? What is the difference between CLOB and Long > Text Buffer in the > datasource settings page?
> The problem is we've had clients complain that the amount > of text retrieved > is not big enough, and I've had to bump up the Long Text > Buffer several > times. Its at 96000 now, and I was wondering what > ramifications this has on > performance and whether I should just enable CLOB instead. They have similar purposes afaik... technically the long-text buffer isn't a clob... clob is supposed to allow you to get the maximum length out of your text or ntext or oracle clob columns, although in the past I've had problems where enabling clob support with sql server meant basically that no data would be returned from the column _at_all_ much less the maximum available... But if it's working properly, that's what it's supposed to do... the Long-Text buffer cap's out at about 100,000 iirc, so you're about at the limit of that without going to CLOB... effect on performance? ... does it matter? If the users say they need more than what the long-text buffer will give them you probably don't have much choice, so the performance issue is likely moot. It does affect performance (which is why there's the long-text buffer option) -- I don't know how much. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208156 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54