search

gajus / xhprof.io

GUI to analyze the profiling data collected using XHProf – A Hierarchical Profiler for PHP.
http://xhprof.io/
Other
429 stars 103 forks source link

use-multi value insert to speedup data persistence #55

Closed staabm closed 10 years ago

staabm commented 10 years ago

In this patch I reworked the save() method to use multi-value inserts instead of prepared statements. this reduces the number of sql queries issued to by a factor of 250.

we measured a considerable speed gain for requests which took 10-20 seconds without this patch to 500ms when this patch is applied.

gajus commented 10 years ago

I will implement a revised version of this suggestion.