Hi Dore,
I'm not sure, that I understand your advice, could you please elaborate a little more? This table (I mean the target shell) has lots of compound indexes.
TIA
>>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.
>
>Depending upon the number of and complexity of the index tags in the structural compound index file it might make sense to decouple the .dbf and .cdx files, do the APPEND FROM, relink the .dbf and .cdx and REINDEX.
If it's not broken, fix it until it is.
My Blog