I have a customer with files at the 600 gig level, we did not go the 64 bit route (for various reasons) but made the files dynamic (this is on udt where dynamic files are held in a directory with separate data blocks as files so you do not get a file over 2 gig). Write performance is fine as it is written to all the time, however we have had instances of corruption on the file, and performing any selects takes hours, this is a fairly high specced ibm machine as well.
Never played with part files, they always feel kind off old school to me for some reason. Rgds Symeon. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: 23 July 2009 02:53 To: U2 Users List Subject: Re: [U2] Performance reports on 4 Terabyte files vs Distributed Files G'day Baker, Just thinking in the sandbox, with no 4Tb databases to be found, BUT (as usual) there may be many aspects to the answer My initial thoughts would be that avoiding running a subroutine to determine part file for EVERY write and non-sequential READ would represent a saving "per transaction". I would assume that such a large file is probably (should be?) well indexed, so there are likely to be some gains on that front. HOWEVER, if the file is primarily used for reporting, and the parts have been crafted with this in mind, I could see there may be situations were being able to "cheat" and deal directly with a part file could be advantageous. However, my gut feel (with sand grit in my teeth) is that the larger 64bit file would win out in most circumstances, but like I said, I don't have a play thing that large at hand :-) Ross Ferris Stamina Software Visage > Better by Design! >-----Original Message----- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Behalf Of Baker Hughes >Sent: Thursday, 23 July 2009 2:01 AM >To: 'U2 Users List' >Subject: [U2] Performance reports on 4 Terabyte files vs Distributed >Files > >Does anyone have any real life examples of performance gains from >converting your large file to 64 bit files? > >Does anyone have a performance comparison of 64 bit files vs. >distributed files. > >I wonder if a 4 terabyte file responds better/faster than a >distributed/part file? SELECTs, WRITES, other access. > >UV 10.2 - I guess UD has the same? > >Thanks, >-Baker > >This communication, its contents and any file attachments transmitted >with it are intended solely for the addressee(s) and may contain >confidential proprietary information. >Access by any other party without the express written permission of the >sender is STRICTLY PROHIBITED. >If you have received this communication in error you may not copy, >distribute or use the contents, attachments or information in any way. >Please destroy it and contact the sender. >_______________________________________________ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users