Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread GUID field storage
Thu, Oct 15 2009 8:48 AMPermanent Link

Leslie
Tim,

Currently  GUID fields seem to be stored as strings ---> 38 bytes (Ansi) / 76 bytes(unicode)   is used on disk & in memory. It could be easly
compressed to 16 bytes max. When I get to use GUID it is mostly because of more complex data synchronization is required, so it has to be
the record ID and the primary key as well. Using 76 byte long field instead of 16 for this has performance implications. My suggestion would be
to make it an  option to use a compact binary format storage for GUID, or having a new dataType, eg  BGUID, if for some reason it is difficult
to implement.

Regards,
Leslie
Thu, Oct 15 2009 9:03 AMPermanent Link

Leslie
Tim,

Do you have any idea why the lines in my messages are broken this way? Am I doing
something wrong, or is it the web page? Or maybe it has something to do with my browser
(Opera) ...

Leslie
Thu, Oct 15 2009 1:58 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Leslie,

<< Currently  GUID fields seem to be stored as strings ---> 38 bytes (Ansi)
/ 76 bytes(unicode)   is used on disk & in memory. It could be easly
compressed to 16 bytes max. When I get to use GUID it is mostly because of
more complex data synchronization is required, so it has to be the record ID
and the primary key as well. Using 76 byte long field instead of 16 for this
has performance implications. My suggestion would be to make it an  option
to use a compact binary format storage for GUID, or having a new dataType,
eg  BGUID, if for some reason it is difficult
to implement. >>

I'll see what I can do.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Oct 15 2009 1:59 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Leslie,

<< Do you have any idea why the lines in my messages are broken this way? Am
I doing something wrong, or is it the web page? Or maybe it has something to
do with my browser (Opera) ... >>

I believe that the web code for the newsgroups inserts the line-breaks
automatically so that the text is readable in newsreaders.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image