Any idea on performance comparison between VARCHAR and CLOB? For example, if I want to insert or update 4000 characters in a field of a row and I am confused whether that column's type would better be decalred as VARCHAR or CLOB, what do you suggest? What is the performance impact of choosing CLOB in this case instead of VARCHAR?
Ashik Uzzaman Senior Member of Technical Staff,
Salesforce.com, San Francisco, CA, USA.
pascal betz
Ranch Hand
Joined: Jun 19, 2001
Posts: 547
posted
0
this is the ORM forum. and i think what you are asking for has more to do with the database system than with java ?
Actually I am using iBATIS with MS SQL Server and I couldn't find out any SQL forum in JavaRanch. Hence I thaught it will be a close fit in this O/R Mappring forum with the hope that Moderators will move it to some other forum if appropriate.
subject: Performance comparison between VARCHAR and CLOB?
0
