Well, this process is still running....and it's up to just about 15M (1.3g) so hopefully, it will be done very soon - I estimated this to take about an hour or so, well, thats turning into almost 20 hours.
I don't know if I have the 64bit option available, I could but something tells me I don't - I'm on version 10.0.2 of UV But if it crashes the process because the file gets too big, I'll have to pare down what gets written out - just less history, this is a file that once it's created, it's exported and rarely used, so it's getting the slow part out of the way once, after that, it runs fast for updating. > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, June 03, 2011 9:46 AM > To: U2 Users List > 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