Derby Char Column Type Versus VarChar

[Mamatha Kodigehalli Venkatesh]

 

 

Hello,

 

Please let us know what will be the performance impact when I use VarChar 
(4000) instead of Char.

I have found that the inserts to the table which contains this change are very 
slow...

 

But on oracle, there is not much of impact on this.

 

Based on the business requirement I need to use VarChar.

 

Any suggestions will be of great help.

 

Thanks

Mamatha