Query optimisation
Chris Muller
asqueaker at gmail.com
Thu Jun 7 00:26:59 UTC 2007
Today I noticed a performance bug; single-clause queries do not need
to go through a (expensive) routine needed only for multi-clause
queries.
A simple guard in the code has now sped up single-clause queries by 100 times.
A single-clause query is one which has no more than one "range" of
keys specified, like:
events where:
[ : each |
each date
between: '1/1/2006' asDate
and: '12/31/2006' asDate ]
Like in older Magma (pre-queries) this is really fast again.
More information about the Magma
mailing list