Performance of registering /huge/ amounts of functions.

[lab27]

More of an observation than a question, but it might be interesting to
anyone else sad enough to spend far too much time with excel. ;)

I've got an addin which dyamically generates and registers VERY large
amounts of functions[*], and I've noticed that the performance of
registration was scaling poorly (approx n^2). Turns out that order of
registration is very important, with excel performing what looks like
a linear scan over previously registered functions to maintain order -
not seen this documented, so I thought I'd mention it here.

If you're registering LOTS of functions, for best behaviour, register
your functions in reverse lexicographic order (with case INsensitive
sorting.)

Detail : http://www.benf.org/excel/regcost/

[*] yes, madness - but it makes sense in context ;)