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). _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
