Unsolved
This post is more than 5 years old
6 Posts
0
854
September 8th, 2011 11:00
ClipId: external storage requirements
What is the datatype and (minimum)length needed to allocate/define space for external ClipId storage? hundreds of millions of rows to allocate the field to so need to be as efficient as possible.
No Events found!
mfh2
208 Posts
0
September 12th, 2011 10:00
Hello AEbstein -
The answer depends on whether you are using XAM or the Centera SDK.
XAM defines an 80-byte binary data type for XUIDs. You could take some XUID storage shortcuts if your XAM app is Centera-only, but then why use XAM?
The Centera SDK defines a 40-byte binary format for content addresses (Canonical format) which is the most efficient storage format but has the inconvenient property of not being directly human-readable in the DB. If you wish to preserve human readability you will need a 53 character latin-1 encoded string column.
Regards,
Mike Horgan