10 Nov
2010
10 Nov
'10
10:25 p.m.
Caleb,
I think that any performance-oriented comparison of keys will use indices.
And in this case, the comparison between strings (even fairly long) and binary bits has
the exact same performance.
paul
On 10 nov. 2010, at 16:50, Caleb James DeLisle wrote:
Is there any
reason to use a varbinary instead of a simple string?
At least string would be easier to export and develop with.
The reason is because varbinary will occupy 16 bytes while a string will occupy 36. This
becomes
important when the database has to find an entry, This will require comparison of the
entries and 16
byte entries will compare about twice as fast as 36 byte entries. If UUIDs are used for
everything
then it's conceivable to have in a document with 10 objects each having 5 properties,
100 lookups
per getDocument. So it's a question of performance vs ease of use (when accessing the
database via
sql).