>>>>>>>>>>>>>
But do not stop investigating, I still think Thomas' multiple SQL suggestion (or pure xBase) would be much faster. Somewhere along the posts I think I saw 50seconds as original timing and that means now around 20-25 which seems very slow to me. Probably you don't have right indexes ?
Cetin

I agree with you, query like this with records count
250x500000 cannot run with time > 1...3 seconds if data are load in cache

Fabio