db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondru...@gmail.com>
Subject Re: Derby Char Column Type Versus VarChar
Date Mon, 05 Apr 2010 14:06:34 GMT
I think Oracle Database and Derby behavior will be same. CHAR(size)
will preallocate size*characters in database page/block whereas
VARCHAR(size) will not. Maybe if you give us any hint what are you
trying to do we could help better. Peter

On Mon, Apr 5, 2010 at 3:41 PM, Mamatha Kodigehalli Venkatesh
<Mamatha.Venkatesh@ness.com> wrote:
> 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
>
>
>
>

Mime
View raw message