Hi Barbara,
It's a good point. We'll try. Thanks for this advice. I let you know, if it improves situation.
Thanks again.
>>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.
>
>
>If it's possible to open the target table EXCLUSIVE, that can speed up the process significantly.
If it's not broken, fix it until it is.
My Blog