Hello there.

U seem to be doing everything right.

I could sugest a more optimised code if I got to know in detail what Exactly you are doing with somuch data.

Some sugestions I would give will be

1 > Index the Tables before processing .
2 > Avoid ReIndex and Pack while processing.
3 > Open all the tables before processing.
4 > Avoid closing and opening the tables.
5 > Before using the 'scan for' loop seek the first matching record.

If I could get a copy of what u were doing I could give u some better optimised code that is only if it needs some Optimization.

Do write back