CiviCRM Community Forums (archive)

I have a D7/CiviCRM 4.3.5 site with a DB with 37K financial transactions. We found it's executing this query:

SELECT civicrm_financial_trxn.id  , civicrm_financial_trxn.payment_instrument_id as payment_method , civicrm_contribution.contact_id as contact_id , civicrm_contribution.id as contributionID , contact_a.sort_name , civicrm_financial_trxn.total_amount as amount , civicrm_financial_trxn.trxn_id as trxn_id , contact_a.contact_type , contact_a.contact_sub_type , civicrm_financial_trxn.trxn_date as transaction_date , name , civicrm_contribution.currency as currency , civicrm_financial_trxn.status_id as status , civicrm_financial_trxn.check_number as check_number
FROM   civicrm_financial_trxn
LEFT JOIN civicrm_entity_financial_trxn ON civicrm_entity_financial_trxn.financial_trxn_id = civicrm_financial_trxn.id
LEFT JOIN civicrm_entity_batch ON civicrm_entity_batch.entity_id = civicrm_financial_trxn.id
LEFT JOIN civicrm_contribution ON civicrm_contribution.id = civicrm_entity_financial_trxn.entity_id
LEFT JOIN civicrm_financial_type ON civicrm_financial_type.id = civicrm_contribution.financial_type_id
LEFT JOIN civicrm_contact contact_a ON contact_a.id = civicrm_contribution.contact_id
LEFT JOIN civicrm_contribution_soft ON civicrm_contribution_soft.contribution_id = civicrm_contribution.id

WHERE   ( civicrm_entity_batch.batch_id IS NULL
        AND civicrm_entity_financial_trxn.entity_table = 'civicrm_contribution')
        ORDER BY transaction_date desc
 LIMIT 0, 10;
and it takes over 300 seconds to execute. I'm guessing it's due to the size of the transactions table, but this is anyhow ridiculous. I'm not sure what page generates this, but can anyone provide any feedback how we can optimize this?