Hi I wonder if it's possible to change the sort order of the keys in an index? By manually recreating the index, but with the key as desc instead of asc, I save myself from sorting a couple of thousands of rows, and makes an improvement of nearly 400% CPU usage, and 200% time usage. However, manually recreating indexes whenever I want to upgrade the scheme isn't feasible |
I've found it, thanks to dotPeek :) Adding :ASC och :DESC to the key name in the IndexAttribute enforces a particular direction :) Sometimes, when all hope is gone, a good reflection tool will save the day.. ;) Yep, it's correct way to do it. 1
I guess, developers don't like to read product documentation. However, it exists on help.dataobjects.net and sometimes even contains answers to questions. 1
Haha, I've started with the docs, then google, and then searching the forums.. I guess I missed, maybe since I was determined I was looking for some property or similar :P |