CLOB vs Long Text Buffer (chr)

S. Isaac Dealey

2005-06-01 00:31:10 UTC

Post by Russ
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=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54