The fix has been committed in the 3.0 and devel branches. Best regards Jan Am Montag, 15. August 2016 10:47:22 UTC+2 schrieb Jan: > > Hi all, > > the root cause for this issue seems to be that the ternary operator is > executed using V8 still. This works but is unintended, as it may execute > slower than executing it natively (in C++). > I am currently working on a fix for this, which should make the original > query as fast as the alternative workarounds. > > Best regards > Jan > > Am Dienstag, 9. August 2016 02:15:41 UTC+2 schrieb BrandonJS: >> >> Both methods worked and are much faster! The TO_BOOL function is a bit >> quicker and I think a bit more concise of the two. >> >> Using TO_BOOL it takes about 1.9 seconds to execute (compared to the ? >> operator's 8 seconds). It only adds about 0.5 seconds to the overall query >> which I think is more than acceptable. >> >> >> Replaced: >> ficoUPB = SUM( IS_NULL(l.Acquisition.BORROWER_CREDIT_SCORE) ? 0 : l. >> Acquisition.ORIGINAL_UPB ) >> >> With either of these: >> ficoUPB = SUM( TO_BOOL(l.Acquisition.BORROWER_CREDIT_SCORE) * l. >> Acquisition.ORIGINAL_UPB) >> ficoUPB = SUM( MIN([1, MAX([l.Acquisition.BORROWER_CREDIT_SCORE, 0 >> ])]) * l.Acquisition.ORIGINAL_UPB ) >> >> Had to do a MIN and a MAX to get l.Acquisition.BORROWER_CREDIT_SCORE to >> be either 0 or 1. >> >> Thanks for the help! >> >
-- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
