Hi.
I edited the code in your site.
File : /components/com_jak2filter/models/itemlist.php Line 112-117
$ifield = 'id, title, alias, catid, published, introtext, video, gallery, extra_fields, created_by, created_by_alias, trash, access, featured, image_caption, image_credits, video_caption, video_credits, hits, params, plugins, language';
$ifield = 'i.'.str_replace(', ',', i.', $ifield);
$query = "SELECT DISTINCT {$xf} {$ifield},{$select_group_tags} CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams";
//$query = "SELECT DISTINCT {$xf} i.*,{$select_group_tags} CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams";
Line 1541-1549:
$searchPattern = $prefix.'"('.implode('|', $refValue).')"';// in category and its children
$likearr=array();
foreach ($refValue AS $rv) {
$likearr[] = 'i.extra_fields LIKE \'%{"id":"'.$fid.'","value":"'.$rv.'"}%\' ';
}
$searchPattern = implode(' OR ', $likearr);
$where[] = '('.$searchPattern.')';
/*$searchPattern = $prefix.'"('.implode('|', $refValue).')"';// in category and its children
$where[] = "(i.extra_fields REGEXP '".$searchPattern."')";*/
Your site now run faster than before. But it’s still slow for united states options because it contains many children. it will be faster if you can disable some more children.
Please remember this code only work for this case not work if you will apply it further .
Regards.
Mo0nlight 8 years ago.
