[fabrice_d]

In general that means looking at the sql query plan for a slow query, and adding appropriate indexes when there are full table scans.