function submitWords with exec_INSERTmultipleRows
|Priority:||Could have||Due date:|
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?
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.
|duplicates Core - Feature #38742: indexed_search performance: function submitWords with exe...||Under Review||2012-06-19|
Updated by Christian Bartolomaeus 12 months ago
Since there was no response and this looked like the wrong place to issue my request I duplicated this feature request: http://forge.typo3.org/issues/38742. (I wasn't able to move this request, so I had to duplicate it.)
This request can be closed/removed.