I knew there was a good math person out there, that could figure that out :) Thanks.
On Fri, Jun 3, 2011 at 10:21 AM, Dan Fitzgerald <dangf...@hotmail.com>wrote: > > Actually, at 64b, the limit is slightly over 9 petabytes. I think that so > far this is theoretical; I'm guessing that nobody yet has put together a > disk array of 9 petabytes and created one large file... > > 2 raised to the (32-1) power is 2,147,483,648 > > 2 raised to the (64-1) power is 9,223,373,036,854,775,808. > > ...so, when you see your file getting above, say, > 9,223,373,036,400,000,000, you may want to break it up into dynamic or > distributed files. > > > Date: Fri, 3 Jun 2011 09:45:46 -0400 > > From: jthompson...@gmail.com > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] File Item Count Limit? > > > > Also, If they are 64 bit files in Universe then they can grow quite large > on > > the disk. > > > > You can have a file that probably takes up to 64 GB of disk space. > > Depending on the record size, etc... who knows how many records that > could > > be. I don't have the formula's in front of me to figure that out. > > > > You can change whether a file is 32 or 64 bit in universe by using the > > RESIZE command. > > Its also a configurable paramater for newly created files in the uvconfig > > file. I think you can easily find it in UniAdmin somewhere. > > > > So even if that file you are referring to is a 32bit one and it exceeds 2 > GB > > on the disk, you can resize it (without users on the system), and turn it > > into a 64 GB file and let it keep growing. > > > > Of course, back it up first as always... > > > > So I think you will be ok, especially if the records don't have much data > in > > them as you say. > > > > On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath <dmc...@imb.com.au> wrote: > > > > > Assuming you're talking about a hash file, I'd hazard a guess that it > > > would be only limited by: > > > 1) File size > > > 2) The ability of the tools to handle the file record list (such as > > > SELECT) > > > 2.1) I.e, memory limitations and > > > 2.2) The count variable (assuming it is a 32bit signed int, that gives > > > you a max 2^31 = 2147483648 records) > > > > > > -----Original Message----- > > > From: u2-users-boun...@listserver.u2ug.org > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > Gallen > > > Sent: Friday, 3 June 2011 6:38 AM > > > To: U2 Users List > > > Subject: [U2] File Item Count Limit? > > > > > > I'm on UV/Linux > > > > > > Just curious, is there a limit to the number of items you can have in a > > > file? or just limited to overall file size? > > > We have one file that has about 15M items at present. Not much data in > > > each item, just a crap load of them. > > > > > > George > > > > > > > > > George Gallen > > > Senior Programmer/Analyst > > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > > ph:856.848.9005 Ext 220 > > > The Wyanoke Group > > > http://www.wyanokegroup.com > > > > > > > > > > > > _______________________________________________ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > ______________________________________________________________________ > > > This email has been scanned by the MessageLabs Email Security System. > > > For more information please visit http://www.messagelabs.com/email > > > ______________________________________________________________________ > > > > > > > ########################################################################################### > > > The information transmitted in this message and attachments (if any) is > > > intended only > > > for the person or entity to which it is addressed. The message may > contain > > > confidential > > > and/or privileged material. Any review, retransmission, dissemination > or > > > other use of > > > or taking of any action in reliance upon this information by persons or > > > entities other > > > than the intended recipient is prohibited. If you received this in > error, > > > please > > > contact the sender and delete the material from any computer. > > > > > > The intended recipient of this e-mail may only use, reproduce, disclose > or > > > distribute > > > the information contained in this e-mail and any attached files with > the > > > permission of IMB. > > > > > > > ########################################################################################### > > > _______________________________________________ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > > > -- > > John Thompson > > _______________________________________________ > > 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 > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users