Bug #23485

Usage of defaultFreeIndexUidList causes identical queries

Added by Thorsten Boock over 8 years ago. Updated about 4 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2010-08-31
Due date:
% Done:

0%

TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

At least in indexed_search version 2.11.0 setting plugin.tx_indexedsearch.search.defaultFreeIndexUidList seems to cause multiple calls of tx_indexedsearch::getPhashList - one for every uid in the list. The query generated / executed in that method is allways identical and thereby causes unnecessary load.

Quick fix: in the method getResultRows_SQLpointer make $list static and check if it allready contains a value different from the default one:

static $list = NULL;
if($list === NULL) {
$list = $this->getPhashList($sWArr);
}
(issue imported from #M15608)

History

#1 Updated by Mathias Schreiber about 4 years ago

  • Description updated (diff)
  • Category set to Indexed Search
  • Target version deleted (0)
  • TYPO3 Version set to 4.5
  • Is Regression set to No

Also available in: Atom PDF