#38742indexed_search performance: function submitWords with exec_INSERTmultipleRows
Description
On different systems I had performance issues with indexed_search due to a vast number of single INSERT queries generated by function submitWords() in class.indexer.php. On different occasions those queries resulted in a bottleneck in disk I/O. Last time that happened was on a system with ext4 filesystem using mount option “barrier” (default settings in CentOS 6).
Looking at the code of submitWords() I suppose it would help to conflate all queries for a given ‘phash’ using TYPO3 function exec_INSERTmultipleRows() instead of exec_INSERTquery(). (At least when using a MySQL backend and not using dbal.)
Attached you find a patch against class.indexer.php (taken from TYPO3 4.7.1). Unfortunately I had no opportunity to test my patch — though I think it should work.
What do you think about my suggestion?
Best regards
Christian