4Go DB with 157 302 nodes

Hi,

I've a huge (4Go) database with 157 302 nodes and more than 1.5 million comments when the views module try to execute the query below it takes 22s to MySQL to return the result, do you have any MySQL or Drupal trick to help me reduce this time? (without using drupal cache)

I'm running this website on a Intel Xeon Quad Core 3220/3330 dedicated server with 8go of memory

SELECT DISTINCT node.nid AS nid,
votingapi_cache_node_points_vote_positives.value AS votingapi_cache_node_points_vote_positives_value,
node.created AS node_created,
users.picture AS users_picture,
users.uid AS users_uid,
users.name AS users_name,
users.mail AS users_mail,
node.title AS node_title,
node.language AS node_language,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
node_comment_statistics.comment_count AS node_comment_statistics_comment_count,
node.vid AS node_vid
FROM node node
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN votingapi_cache votingapi_cache_node_points_vote_positives ON node.nid = votingapi_cache_node_points_vote_positives.content_id AND (votingapi_cache_node_points_vote_positives.content_type = 'node' AND votingapi_cache_node_points_vote_positives.value_type = 'points' AND votingapi_cache_node_points_vote_positives.tag = 'vote' AND votingapi_cache_node_points_vote_positives.function = 'positives')
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
WHERE (node.status <> 0) AND (node.type in ('poll', 'dua', 'link', 'photo', 'quote', 'text', 'video'))
ORDER BY node_created DESC
LIMIT 0, 50;