and the FILE.STAT? On 10/16/07, roy <[EMAIL PROTECTED]> wrote: > Random reads and updates on a file with ~2 million records. I separated the > reads and writes to a separate program that only does this processing to no > avail. > > Topas shows 100% disk usage during this process and all other users are > affected. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald > Sent: Tuesday, October 16, 2007 1:14 PM > To: [email protected] > Subject: RE: [U2] Size of Key Question > > I wouldn't expect much difference in file access speed with long record > keys versus short keys. What are you doing with the file that seems > slow? -- i.e. random reads of individual records, updates, sequential > selects and processing, etc. If the slowness is seen in an application > program, are there other possibilities? Does the file have alternate > keys or associated files that might be causing the slowness? Could > locking be a bottleneck? Just for grins it would be interesting to see > a FILE.STAT on the file. > > Jeff Fitzgerald > Fitzgerald & Long, Inc. > www.fitzlong.com > > -----Original Message----- > From: Roy Beard [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 16, 2007 12:17 PM > To: '[email protected]' > Subject: Size of Key Question > > > > Can someone comment on what effect if any the length of the key has on > the speed of disk access? The software I am working with has one file > with a complex key of 64 alpha-numeric characters and that file seems > to be very slow no matter the modulo and sep or even file type I choose. > This is in UV > 10.2 Pick Flavor on AIX 5.3 > > > > Any insight would be appreciated. > > > > Thanks, > > > > > > 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/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ >
-- john ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
