Skip to content

Instantly share code, notes, and snippets.

@tractorcow
Created October 15, 2013 22:37
Show Gist options
  • Select an option

  • Save tractorcow/6999768 to your computer and use it in GitHub Desktop.

Select an option

Save tractorcow/6999768 to your computer and use it in GitHub Desktop.
- Mac OSX - MySQL (mysqli parameterised)
Rua-Hotseat:framework rua$ ./sake dev/benchmarks/all "flush=all"
SQLBENCHMARK
------------
SQLBENCHMARK
benchmarkSelect
---------------
Select all pages: 0.000975 seconds (50 iterations)
Select top level pages: 0.001184 seconds (50 iterations)
Select home page: 0.001167 seconds (50 iterations)
Performance of DataList->relation: 0.002934 seconds (50 iterations)
Aggregate query (SUM): 0.000797 seconds (50 iterations)
Aggregate query (SUM) with condition: 0.001086 seconds (50 iterations)
SQLBENCHMARK
benchmarkMethods
----------------
Select top level pages using DB::query: 0.000174 seconds (50 iterations)
Select top level pages using DB::prepared_query: 0.000169 seconds (50 iterations)
SQLBENCHMARK
benchmarkCreate
---------------
Create DataObject: 0.002786 seconds (50 iterations)
Create and publish page: 0.060431 seconds (50 iterations)
Total time: 13.905 seconds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment