Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Performance comparison between VARCHAR and CLOB?

 
Ashik Uzzaman
Ranch Hand
Posts: 2373
Eclipse IDE Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
pascal betz
Ranch Hand
Posts: 547
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2373
Eclipse IDE Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic