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 Software Engineer, TubeMogul, Emeryville, CA, USA.
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.