Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Smackdown: CLOB vs. VarChar
Tue, Jul 15 2008 10:34 AMPermanent Link

David Loving
Question for Tim and anyone else working with ElevateDB 2.x and Microsoft VS C#.

Which is a better way to persist a Microsoft Unicode WideString in ElevateDB... CLOB or VarChar(512 or less)?

Which is the fastest?  Which is the most efficient?

David L.
Tue, Jul 15 2008 12:49 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

David,

<< Which is a better way to persist a Microsoft Unicode WideString in
ElevateDB... CLOB or VarChar(512 or less)?

Which is the fastest?  Which is the most efficient? >>

If you don't have to index the column, then definitely use a CLOB type for
the column.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jul 15 2008 1:50 PMPermanent Link

David Loving
Excellent!  Thanks!

David L.
Image