Query performance improvement

Hi all,

during my tests on HS, trying to find a solution to speed up the component, I found there are generated by the component lots of slow query. All the ones are similar to the next one:

SELECT COUNT(*)
FROM   (SELECT DISTINCT( node.nid ) AS nid,
                       node.TYPE AS node_type,
                       node.vid AS node_vid,
                       node_data_field_codice_web.field_codice_web_value AS
                       node_data_field_codice_web_field_codice_web_value,
                       node.LANGUAGE AS node_language,
                       node.title AS node_title,
                       node_revisions.teaser AS node_revisions_teaser,
                       node_revisions.FORMAT  AS
                              node_revisions_format,
                       node_data_field_codice_web.field_indirizzo_value  AS
                       node_data_field_codice_web_field_indirizzo_value,
                       node_data_field_codice_web.field_vani_value AS
                       node_data_field_codice_web_field_vani_value,
                       node.created AS node_created,
                       node_data_field_codice_web.field_trattativa_value AS
                       node_data_field_codice_web_field_trattativa_value,
                       users.name AS users_name,
                       users.uid AS users_uid,
                       users.picture AS users_picture,
                       users.mail AS users_mail,
                       node_data_field_codice_web.field_prezzo_value     AS
                       node_data_field_codice_web_field_prezzo_value,
                       node_data_field_indirizzo.field_indirizzo_value   AS
                       node_data_field_indirizzo_field_indirizzo_value,
                       node_data_field_indirizzo.field_prezzo_value      AS
                       node_data_field_indirizzo_field_prezzo_value,
                       node_data_field_indirizzo.field_vani_value        AS
                       node_data_field_indirizzo_field_vani_value
        FROM   node node
               INNER JOIN term_node term_node_value_0
                 ON node.vid = term_node_value_0.vid
                    AND term_node_value_0.tid = 57
               LEFT JOIN content_type_annuncio_immobiliare
                         node_data_field_codice_web
                 ON node.vid = node_data_field_codice_web.vid
               LEFT JOIN node_revisions node_revisions
                 ON node.vid = node_revisions.vid
               INNER JOIN users users
                 ON node.uid = users.uid
               LEFT JOIN content_type_annuncio_immobiliare
                         node_data_field_indirizzo
                 ON node.vid = node_data_field_indirizzo.vid
        WHERE  ( term_node_value_0.tid = 57 )
               AND ( node.status <> 0 )
               AND ( node.TYPE IN ( 'thetype' ) )
               AND ( node.LANGUAGE IN ( 'en' ) )
        GROUP  BY nid
        ORDER  BY node_data_field_indirizzo_field_indirizzo_value ASC,
                  node_data_field_indirizzo_field_prezzo_value ASC,
                  node_data_field_indirizzo_field_vani_value ASC) count_alias

These queries are very slow! So, I tryied to find the way to optimize them, like adding some index to the Drupal tables, but I didn't find the way to do it.

Would be great if some solution should be added to the installation file of the module.

Did anyone have just solved this problem? Can someone help?

Thanks.