Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
GUID field storage |
Thu, Oct 15 2009 8:48 AM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Friday, April 19, 2024 at 07:09 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |