Brenda, We have several, each part is Type 30 / Dynamic. Our Distributed Files have only four to six parts, in general.
No discernable bad impacts on performance, some things have improved performance because only one part-file is scanned instead of the whole file. We have no 64-bit files and no intention of having any, when we get close to 2GB we'd rather partition than go 64-bit. Frankly, we're a bit leery of 64-bitness. The only time I remember us using a 64-bit file (apart from just playing in Development to see if they worked at all) was when we wanted to change the partitioning algorithm on one of our larger distributed files. It was easier to create a temporary 64-bit file, copy all the records from the distributed file to it, clear the part files, reset the partitioning algorithm and move the part files, then copy the data all back again. Then we deleted the temporary 64-bit file. Oh, we're on Windows 2003 Server, UV 10.1 Regards Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Thursday, 24 January 2008 10:56 a.m. To: [email protected] Subject: [U2] Distributed files poll How many sites use distributed files? Any issues you have with them? Do they impact system performance? Which would you prefer, a distributed file or a 64-Bit file to get around the 2 gig limit. Brenda L Price Senior Programmer Analyst Affiliated Acceptance Corporation Sunrise Beach, MO (800)233-8483 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
