Thanks for the responses.

My test version of the program is running from my PC only, the live version runs directly from an NT Server.

I have opened the tables exclusively, taken out repeated statements (these were mainly SET EXACT and SET ORDER) and this has increased the speed to 0.52 seconds.

The program consists mainly of:

IF SEEK(ParentTable.Value)
*!* DO STUFF Here *!*
ENDIF

I can't think of anything else, am I expecting too much, I personally think it's quite fast, considering the amount of tables that have to be processed.

Kev