Re: [U2] UDT dynamic files

Richard Sammartino Thu, 17 Mar 2005 13:28:15 -0800

Chuck, Is the file indexed? I have noticed an improvement in copying speed on an indexed file by not having any indexes created on the target file. I create the index after the copy. It is just a thought.

Rich Sammartino

At 02:20 PM 3/17/2005 -0500, you 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/

Richard Sammartino Systems Analyst Information Technology School District of Philadelphia 734 Schuylkill Avenue Philadelphia, PA 19146-2397 Phone: (215) 875-4734 Fax: (215) 893-4243 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UDT dynamic files

Reply via email to