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