----- 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
