KEYONLY would not work for us for the most part. We have File Keys that
were 10-15 characters. Our record sizes would be 300-800. So we would never get
enough Keys in a group to cause splitting. KEYDATA works fine in 90% of our
files. But we have files that have meaningful keys that do not hash well. Keys
like this do poorly with hashing in Unidata:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
And they are a disaster with KEYDATA. Splitting happens continuously as
the hashing causes records to hash to the same groups even after the split. So
I had to go back to KEYONLY and I manually have to resize these files with
meaningful keys on a yearly basis.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Davis
Sent: Tuesday, July 24, 2007 8:27 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Converting static to dynamic
Use hash type 1.
Use KEYONLY splitting.
Choose a reasonable starting modulo
Experiment with SPLIT.LOAD and MERGE.LOAD.
The file will probably be twice as slow as a perfectly sized static file
but who cares.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Leckie
Sent: Tuesday, July 24, 2007 4:06 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Converting static to dynamic
We have two very large files from which I often have to remove data to
stop the files reaching the 2GB limit, much as I enjoy removing this
data my colleague has suggested that changing these files to be dynamic
would mean we could allow them to hold more data and choose when to
remove old data rather than be forced to.
Does any one have any experiences that they wish to share regarding
changing files in this way, e.g. file performance before and after, any
practical steps required after conversion etc.?
We are running red hat enterprise Linux 3 and unidata 6.
--
A Striker is the same as a Keeper.
--
************************************************************************
* This message has been scanned for viruses and dangerous content by
* Blairs MailScanner, and is believed to be clean.
*
* This email and any files transmitted with it are confidential and
* intended solely for the use of the individual or entity to whom they
* are addressed.
*
* If you have received this email in error please notify us at Blairs
* via email at [EMAIL PROTECTED]
*
* Name & Registered Office:
* --------------------------
* Blairs Limited
* 9 Baker Street
* Greenock
* PA15 4TU
* Company No: SC132926
* VAT No: 554698690
************************************************************************
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
