Feature #38178
closed
function submitWords with exec_INSERTmultipleRows
0%
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.
Files
Updated by Christian Bartolomaeus almost 12 years 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.
Thanks
Christian
Updated by Oliver Hader over 11 years ago
- Project changed from 1382 to TYPO3 Core
Updated by Anja Leichsenring almost 10 years ago
- Status changed from New to Closed
please follow updates on #38742, after this is a duplicate.