Requete de comptage personnalisée

juansolos
Topic Author
Offline
Elite Member

10 years 11 months ago #43077 by juansolos

Requete de comptage personnalisée was created by juansolos

Bonjour,
j'utilise jumi pour insérer du php.
Ce code php compte les items flexicontent qui ont la valeur V pour le champs C.
Plusieurs scripts php sont appelé dans la page avec une valeur V différentes pour ce même champs.

La requête n'est peut être pas optimisée. Car la page met énormément de temps à se charger.
Une aide?
une requete :

Code:

$db = JFactory::getDbo();
$sql = "SELECT COUNT(distinct o.item_id) FROM #__flexicontent_fields_item_relations as o"
	." INNER JOIN #__content as c"
	. ' WHERE o.field_id = "C" AND (o.value = "V1") AND c.state="1"';
		
		$db->setQuery($sql);
		$result = $db->loadResult();

Please Log in or Create an account to join the conversation.

juansolos
Topic Author
Offline
Elite Member

10 years 11 months ago #43084 by juansolos

Replied by juansolos on topic Requete de comptage personnalisée

Celle ci serait elle plus rapide.
Qu'en pensez vous?

Code:

$sql =	'SELECT COUNT(distinct c.id) FROM #__content AS c '
				.' JOIN #__flexicontent_fields_item_relations as o  '
				.' ON c.id=o.item_id AND o.field_id = "C" AND  c.state="1" '
				. ' WHERE o.value = "V1"';

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 11 months ago #43085 by ggppdk

Replied by ggppdk on topic Requete de comptage personnalisée

Hello

did you measure time to execute this query ?

you execute it more than once in the same page ?

about page execution time, did you also try to print performance statistics ? (enable in FLEXIcontent component parameter, at the first tab near the top)
-- note the time need for this query maybe include in the "template rendering" part

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.