----- Original Message -----
Sent: Thursday, January 29, 2004 5:53
PM
Subject: RE: Distributed & multipart
files [as RE: [UV] Resize - Dynamic or64 bit?]
Hi
Stuart,
One
large advantage (from my perspective) is the ability to address the file as
one large file or as an single part individually. The open statement in the
program is the same, only the name changes.
The
ability to put the parts on different file systems, balancing the load is
another that springs to mind. The ability to split a file into manageable
chunks is another. Some of our tables are starting to stretch toward the 20Gb
mark and to split these into manageable chunks makes for reasonable resizing
times etc. The individual parts can be resized at different
times.
The
ability to split your data according to your own algorithm is especially
useful.
With
multi-data part files, I don't believe you could address the complete file as
one, other than that, the other points I have made are still applicable. I
suppose distributed files are easier to deal with from the application point
of view. If your distribution algorithm is reasonably well balanced the
records will be placed evenly over the individual parts. Even if they are not,
eg. you use say, a branch code as the key, you don't have to worry
about opening up the correct multi-part, the system will automatically do that
for you.
Regards
David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273
+61 417 268 665
I have never come across distributed files in a system and
they sound a lot like multiple part files (like
SYS.HELP,XXX).
What is the difference / advantages / disadvantages between
using distributed files and multiple data-part files? Can a
distributed file also be a multiple part file?
Cheers,
Stuart
Actually, a DISTRIBUTED file
is largely a logical construct. It is a
collection of normal
files under the umbrella of a master logical file.
The components of
the DISTRIBUTED file (also called a PART file) can be
any hashed file
type.
The file type that has DATA.30 and OVER.30 is a DYNAMIC file.
Dave
**********************************************************************
This
email message and any files transmitted with it are confidential
and
intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support
Centre (61 3 9269 7555) immediately who will advise further
action.
This footnote also confirms that this email message has been
scanned
for the presence of computer
viruses.
**********************************************************************
_______________________________________________
u2-users mailing
list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users