I preselect 20-30K ticks, that fits nicely into 256K L2 cache. All integer arithmetics (no floats), hand optimized.
Duh good it is... What's your hardware, OS, Oracle version?
I'm doing 250M ticks * combinations with a $60 Celeron. Are you using c++ or python?
From my journal: " ------------------------------------------------------------------------ 11 Nov 03...
250K * 252 days * 10 years ~= 1B arithmetical operations. My $60 Celeron will do it in few seconds. Any institutional interested in leasing...
My $60 Celeron does 2.4 BILLION operations a second (actually more, because it can do some operations in parallel)
Separate names with a comma.