phpunit-clever-and-smart icon indicating copy to clipboard operation
phpunit-clever-and-smart copied to clipboard
verified publisher icon lstrojny

Batch insert / update

Open staabm opened this issue 12 years ago • 3 comments

Investigate if pushing each insert/update to a queue and and execute it in batches in a shutdown function would reduce IO and speedup things.

staabm avatar Jan 18 '14 13:01 staabm

Could you elaborate a little, I don’t get it yet.

lstrojny avatar Jan 18 '14 22:01 lstrojny

The idea is: instead of insert/update the db on each errored/successfull test we could store the results in a data structure and insert everything on shotdown... At least in mysql there are multi value insert statements which are a lot faster then insert row per row.

staabm avatar Jan 19 '14 01:01 staabm

Ah, makes sense. Let’s wait for the results from #15 and than decide where to go from there.

lstrojny avatar Jan 19 '14 17:01 lstrojny