DataView.Rowfilter its taking much time

Question

I am using DataView.Rowfilter for getting one single row from a table for particular condition.but its taking much time, because m refering a table of thousand records around five hundred times...
so is there any other way to reduce the time for same functionality...
if we use for loop whether it will reduce the time?