Issue Feature Closed

#38742indexed_search performance: function submitWords with exec_INSERTmultipleRows

Christian Bartolomaeus 07/08/12, 09:55 updated 10/02/18, 12:42

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

Reviews 1