Multi-threaded sort takes more overheads. The more data, the lesser the proportion of overhead. You seem you have found roughly the break-even point.
(In larger countries than NZ, 210 MB is not a lot of data!) Why not post your question at [EMAIL PROTECTED] ? > ----- Original Message ----- > From: "HENDERSON MIKE, MR" <[EMAIL PROTECTED]> > To: [email protected] > Subject: RE: [U2] [UV] Upgrading to UV10.1.x - UVTSORT Config parameter > {Unclassified} > Date: Tue, 16 May 2006 15:58:09 +1200 > > > Ray, > > One data point so far: > HP BL-20 blade, two 'HYPErthreading' Intel Xeon CPUs (looks like > 4 CPUs to O/S) > Sort ~210MB file with ~2.3M records by @ID (multi-character > alphanumeric value, e.g. "E996893|13787|DFA-OPH2|21") > Only user on system > Two runs in each pass, reboot between passes > Pass 1 > UVTSORT = 0 > 1st run 0:59 > 2nd run 0:18 (file all in memory) > Pass 2 > Re-boot, then > UVTSORT = 1 > 1st run 1:00 > 2nd run 0:19 (file all in memory) > > Thanks to Andy Mack for actually doing the work! > > Multi-threading is no faster, maybe even ~2% slower than > non-multithreading? > > > Mike > > > > -----Original Message----- > > From: [EMAIL PROTECTED] On Behalf Of Ray Wurlod > > Sent: Tuesday, 16 May 2006 14:56 > > To: [email protected] > > Subject: Re: [U2] [UV] Upgrading to UV10.1.x - UVTSORT Config > > parameter {Unclassified} > > > > Windows is usually happy with multiple threads in a process. > > If you have the opportunity, try it both ways, and let us > > know whether you see any difference when sorting large > > numbers of records (and/or multi-level sorts). As far as I > > am aware (from hints dropped over the years by such as Dave > > Meeks and Glenn Herbert), UniVerse sorting has always been > > multi-threaded, so this may just be an opportunity to switch > > it off for platforms where multi-threading is a bit flaky. > > Windows is definitely not in that category. > > ------- > > 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
