If you're adding a lot of records to the archives at once and it was
undersized, you're going to pay a hit while the system resizes on the
fly. If you're dramatically increasing the record count, it would be
better to resize before copying. Just as it's better to turn off
indexing when copying records and rebuilding the index.
Roger
Chuck Mongiovi wrote:
Does anyone know what kind of a perfomance hit you take for using dynamic
files? .. I had thought that it was pretty minimal, since splitting
shouldn't occur too much, and merging almost never happens ..
Anyway, I was archiving data off of a dynamic file today and noticed that a
COPY command was taking a really long time .. I re-wrote the copy in BASIC
so I could put in display counters and got the same results .. I did some
testing and found that doing the same process (READ/COPY/DELETE) using a
STATIC file is faster by a factor of about 10 ..
Any ideas?
-Chuck
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
