Parameterised query performance

gistfile1.sh

$ ./sake dev/benchmarks/all "flush=all"
SQLBENCHMARK

------------


SQLBENCHMARK
benchmarkSelect
---------------


Select all pages: 0.00414 seconds (50 iterations)

Select top level pages: 0.0055 seconds (50 iterations)

Select home page: 0.00534 seconds (50 iterations)

Performance of DataList->relation: 0.013001 seconds (50 iterations)

Aggregate query (SUM): 0.0036 seconds (50 iterations)

Aggregate query (SUM) with condition: 0.00486 seconds (50 iterations)

SQLBENCHMARK
benchmarkCreate
---------------


Create DataObject: 0.047303 seconds (50 iterations)

Create and publish page: 0.337679 seconds (50 iterations)



Total time: 37.105 seconds