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