Issue Feature Closed

#38178function submitWords with exec_INSERTmultipleRows

Christian Bartolomaeus 06/19/12, 18:12 updated 09/27/14, 08:46

Description

On different systems I had performance issues 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

P.S. This is the first time I open a new issue on forge.typo3.org. I hope I found the right place (and words) to post my feature request.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.