Dup Check

[greg252]

Is there a better way?
I have a 3 field table: ind Primary Key, disk varchar, file varchar
6400 records and I need to find dups where disk && file are repeated.

Tried self join, but times out after 5 mins.
Should I increase php time limit or is there a better way to do this?

[Lars_Berg]

select disk,file
  from t
group by disk,file
having count(*) > 1