I suppose one last thing you can do is give it as much memory as possible
have a look at sys(3050)
And 1 final suggestion - run it on FPD2.6, it will hog the processor and grab as much memory as possible so don't expect to be able to use the server for anything else!
Will
>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
Will Jones