Feature #38178

function submitWords with exec_INSERTmultipleRows

Added by Christian Bartolomaeus 12 months ago. Updated 3 months ago.

Status:New Start date:2012-06-19
Priority:Could have Due date:
Assignee:- % Done:

0%
Category:indexed search
Target version:-
TYPO3 Version: Complexity:
PHP Version:
Votes: 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.

patch - patch for class.indexer.php (1.1 kB) Christian Bartolomaeus, 2012-06-19 18:12

Related issues

duplicates Core - Feature #38742: indexed_search performance: function submitWords with exe... Under Review 2012-06-19

History

#1
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.

Thanks

Christian

#2
Updated by Oliver Hader 3 months ago

  • Target version set to 2222

#3
Updated by Oliver Hader 3 months ago

  • Project changed from Indexed Search to Core

#4
Updated by Oliver Hader 3 months ago

  • Category set to indexed search

#5
Updated by Oliver Hader 3 months ago

  • Target version deleted (2222)

Also available in: Atom PDF