Skip to content

Instantly share code, notes, and snippets.

@tractorcow
Last active December 25, 2015 13:29
Show Gist options
  • Select an option

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

Select an option

Save tractorcow/6983906 to your computer and use it in GitHub Desktop.
mysqli - With parameterised statement caching
$ ./sake dev/benchmarks/all "flush=all"
SQLBENCHMARK
------------
SQLBENCHMARK
benchmarkSelect
---------------
Select all pages: 0.00416 seconds (50 iterations)
Select top level pages: 0.00512 seconds (50 iterations)
Select home page: 0.00506 seconds (50 iterations)
Performance of DataList->relation: 0.012401 seconds (50 iterations)
Aggregate query (SUM): 0.00338 seconds (50 iterations)
Aggregate query (SUM) with condition: 0.00464 seconds (50 iterations)
SQLBENCHMARK
benchmarkMethods
----------------
Select top level pages using DB::query: 0.0003 seconds (50 iterations)
Select top level pages using DB::prepared_query: 0.0004 seconds (50 iterations)
SQLBENCHMARK
benchmarkCreate
---------------
Create DataObject: 0.047683 seconds (50 iterations)
Create and publish page: 0.34098 seconds (50 iterations)
Total time: 39.673 seconds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment