My thought on seeing the keys is that the key is being used for things that should be in the data, not the key... My feeble 2-bits.
Karl On Wed, 2007-10-17 at 09:51 -0400, roy wrote: > _____ > > From: Roy Beard [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 16, 2007 10:33 PM > To: '[email protected]' > Subject: File key question > > > > Wow! > > > > I got so many ideas from this group that I thought I would give some more > Information. > > > > This file is a distributed file in 2 parts The 3rd field (separated by *) > determines which partfile with "1" going to the file I sent before and the > rest going to this file > > > > There are no triggers on the file. > > > > The system was 'fast' until recently when tens of thousands of new records > were added. I agree the file is poorly sized, it was an attempt to solve > one problem but created another. > > > > The keys, I believe, are an issue > > > > Here is a sample > > &SUMMARY&*PRO*1*&SUMMARY&*CDJ*9876***WS > > 407*BAR*1*498*GLU*2274***&SUMMARY& > > 491*BAR*1*498*GLU*2274***&SUMMARY& > > &SUMMARY&*BAR*1*498*GLU*2274***&SUMMARY& > > 1896*BAR*1*498*GLU*2274***&SUMMARY& > > 460*BAR*1*498*GLU*2274***&SUMMARY& > > 1199*&SUMMARY&*1*465*432*9999*** > > 1185*&SUMMARY&*1*412*ABE*&SUMMARY&***BLIN > > 3281*&SUMMARY&*1*412*ABE*&SUMMARY&***BLIN > > &SUMMARY&*&SUMMARY&*1*412*ABE*&SUMMARY&***BLIN > > &SUMMARY&*&SUMMARY&*1*450*HIR*&SUMMARY&***AMEL > > 3558*&SUMMARY&*1*450*HIR*&SUMMARY&***AMEL > > 3811*&SUMMARY&*1*450*HIR*&SUMMARY&***AMER > > &SUMMARY&*&SUMMARY&*1*450*HIR*&SUMMARY&***AMER > > 3558*&SUMMARY&*1*450*HIR*&SUMMARY&***AMER > > &SUMMARY&*CAG*1*429*LOR*1810***BURN > > 252*PON*1*640*SHE*FRT*** > > 2177*CS1*1*491*ABE*&SUMMARY&*** > > 590*PRO*1*491*JOR*&SUMMARY&***WW8RHH > > 3715*PRO*1*491*JOR*&SUMMARY&***WW8RHH > > Press any key to continue... > > > > Here is the file stat from the other half of the file File name > = SALES-HIST-BRS > > File type = 18 > > Number of groups in file (modulo) = 3000017 > > Separation = 1 > > Number of records = 2071678 > > Number of physical bytes = 1894588928 > > Number of data bytes = 356514112 > > > > Average number of records per group = 0.6906 > > Average number of bytes per group = 118.8374 > > Minimum number of records in a group = 0 > > Maximum number of records in a group = 18032 > > > > Average number of bytes per record = 172.0895 > > Minimum number of bytes in a record = 64 > > Maximum number of bytes in a record = 2704 > > > > Average number of fields per record = 25.7575 > > Minimum number of fields per record = 11 > > Maximum number of fields per record = 41 > > > > Groups 25% 50% 75% 100% 125% 150% 175% 200% full > > 2789365 44352 31348 23325 33111 9221 9893 59402 > > Press any key to continue... > > > > > > I'll be working on this for a while. Any resize, copy etc. has such an > impact on the system that my access is limited. > > > > Thanks for the input so far. > > > > Roy > > > > > > > > > > > > > > Roy C. Beard > > Distributor Solutions Inc > > P.O. Box 110520 > > Palm Bay, FL 32911-0520 > > > > 321-956-6500 > > 501-642-8698 Fax > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ --- Karl L. Pearson [EMAIL PROTECTED] http://consulting.ourldsfamily.com --- My Thoughts on Terrorism In America right after 9/11/2001: http://www.ourldsfamily.com/wtc.shtml --- The world is a dangerous place to live... not because of the people who are evil, but because of the people who don't do anything about it. - Albert Einstein --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Now for a random _short_ fortune: While having never invented a sin, I'm trying to perfect several. --- ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
