Hi Nick,
I looked into this program closely (my pearce wrote it) and found, that firstly it appends from hugetable, then replace all in hugetable. So, IMO, the first step should be combine these two operations together in one INSERT INTO command within SCAN..ENDSCAN.
>>Hi everybody,
>>
>>We're having this problem: our SQL produces ~1000000 records. SQL works fast. Then we need to place this records into Database with predefined structure, indexes, etc. So, firstly it prepares a shell Database and a table and then uses Append from command (runs DeNull program in between). This operation takes already ~15 min. and it's not finished yet. What can you suggest to optimize it?
>>
>>Thanks in advance.
>
>APPEND FROM is not Rushmore optimizable
If it's not broken, fix it until it is.
My Blog