Ciao,
Mi sarei aspettato che la seconda fosse + veloce prima
codice:
SELECT `np_petition`.`id`, count(np_sign.id) AS `total_sign` 
FROM `np_petition` 
INNER JOIN `np_sign` ON np_petition.id = np_sign.petition_id 
WHERE (np_petition.STATUS = 'approved' OR np_petition.STATUS = 'confirmed' OR np_petition.STATUS = 'stopped') 
GROUP BY `np_petition`.`id` 
ORDER BY `np_petition`.`registration_datetime` DESC
 
SELECT `np_petition`.`id`, count(np_sign.id) AS `total_sign` 
FROM `np_petition` 
INNER JOIN `np_sign` ON np_petition.id = np_sign.petition_id 
WHERE np_petition.STATUS IN ('approved' ,'confirmed' , 'stopped') 
GROUP BY `np_petition`.`id` 
ORDER BY `np_petition`.`registration_datetime` DESC
invece
la prima restituisce i risultati in 8.3 secs
la seconda in 11.5

A livello di prestazioni IN non dovrebbe essere + performante di
un where con diversi OR ?
o sbaglio