• 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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!