I mentioned in my last post that I would update the code for the SetHyperlinkVariable
add-in to use BatchUpdate instead of iterating over each file. I figured I would do a little testing and see which is actually more efficient.
I tested using both IEdmEnumeratorVariable8 and IEdmBatchUpdate2 on 20 files. IEdmBatchUpdate2 out-performed IEdmEnumeratorVariable8 each time, sometimes as much as 2:1. I assume the main reason is because of the SQL behind the scenes; BatchUpdate does just what it says, it updates the SQL in one batch whereas the Enumerator does each file.
But there is a catch
IEdmBatchUpdate2 will not update a variable unless it is part of a data card. If the variable you wish to update is not part of a data card, it won’t update the database. This could cause issues if you don’t have a data card for each file type you’re adding. Something to remember.
The changed code is available here: EPDMSetHyperlinkVariable.zip (232.66 kb)