so... does the order by formula command make use of the index on an index field?
quick answer is: it is supposed to...
here are some tests in 4d v11.3 on 1 million records to show it...
ORDER BY (non-indexed field): 7095 ms
ORDER BY (indexed field): 294 ms
ORDER BY FORMULA (non-indexed field): 19720 ms
ORDER BY FORMULA (indexed field): 19743 ms
QUERY BY FORMULA (non-indexed field): 22498 ms
QUERY BY FORMULA (indexed field): 22419 ms
quick answer is: it is supposed to...
here are some tests in 4d v11.3 on 1 million records to show it...
ORDER BY (non-indexed field): 7095 ms
ORDER BY (indexed field): 294 ms
ORDER BY FORMULA (non-indexed field): 19720 ms
ORDER BY FORMULA (indexed field): 19743 ms
QUERY BY FORMULA (non-indexed field): 22498 ms
QUERY BY FORMULA (indexed field): 22419 ms
it's getting faster :m)
No comments:
Post a Comment
The internet is a crazy place so please help us keep it under control by leaving only relevant messages and comments, thanks a bunch! :m)