Hello,
I have been playing around with importing large collections into a DTP DB via scripts, also timing the required times.
Following Bill’s suggestion I did Verify and, if OK, Backup and Optimize in varying intervals. What I observed was:
Optimizing does not always have an effect on subsequent import times, but usually makes them faster. This would depend on RAM and the intervals between optimizing, I guess.
But, surprise!, quitting DTP, relaunching it, then opening the database has a MUCH greater effect on the next imports, and is also 1/3 to 2/3 times faster than optimizing.
Can I safely discard the verify-optimize routine and rely on relaunching or would there be dangers lurking somewhere?
Greetings,
Br@