aspose file tools*
The moose likes Object Relational Mapping and the fly likes Performance comparison between VARCHAR and CLOB? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Performance comparison between VARCHAR and CLOB?" Watch "Performance comparison between VARCHAR and CLOB?" New topic
Author

Performance comparison between VARCHAR and CLOB?

Ashik Uzzaman
Ranch Hand

Joined: Jul 05, 2001
Posts: 2370

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
this is the ORM forum. and i think what you are asking for has more to do with the database system than with java ?


pascal
Ashik Uzzaman
Ranch Hand

Joined: Jul 05, 2001
Posts: 2370

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Performance comparison between VARCHAR and CLOB?