>Yes. However I tried it and it's at least two times faster in worst case (found recs need skip to first recs in table). It was 2-400 times faster compared to SQL.

Thanks for the analyses, but this will still represent about 10 seconds in worst case where I have to return the transaction in .5 at most.

This thread however shade some light on the topic and it gave me various approaches I could use in similar situations in the future.