[scoriae]

Greetings folks.

First time poster here. I apologize if I did put this in the wrong forum. I should also state, I have basic knowledge in MySQL, but not enough to be able to come up with a viable solution by myself.

The host (GoDaddy) has shut down the dkp database temporarily due to a certain query going through excessive amounts of records on a shared host. (Reportedly looking at 1,217,889 rows of data, an unacceptable amount for shared hosting).
The letter has only mentioned one specific query to be the culprit at this point in time.

SELECT e.event_id, r.raid_name, count(ra.raid_id) AS raid_count
FROM dkp_events e, dkp_raid_attendees ra, dkp_raids r
WHERE (e.event_name = r.raid_name)
AND (r.raid_id =
ra.raid_id)
AND (ra.member_name = 'scoriae')
AND (r.raid_date >= 1200000000)
GROUP BY
ra.member_name, r.raid_name

Some portions have been changed for anonymity sake.

I understand what this query does, and have run it using different members and raid dates to varying results. A member who has been in the records and still playing after 7 years takes this query anywhere between 30s to 1m15s to execute, while someone playing for just under a year takes about 3 seconds. My problem is on how to approach the situation in a clean and elegant fashion, to reduce stress on the host. Any advice on this would be greatly appreciated =)