in reply to Re^4: external sort performance improved?
in thread external sort performance improved?

I am getting the warning as "Warning: the specified memory size is being reduced to the available paging memory".The paging file size of this system is set to 12284 MB.(Even when I run this on w2k8 64 bit 12GB RAM system

That is just a warning, it doesn't prevent the sort from working. I'm not sure if it is a bug in the way the program determines the amount of memory available; or if the "paging memory" it talks of is some specialised subset of the available memory.

Either way, when you get that warning, it means the program will use the maximum amount it thinks it can use.

The output of sort which you have mentioned and output of my code differs ...

That's unfortunate. sort.exe doesn't have a way to restrict the key length.

The next fastest solution would be to download GNU CoreUtils and either put the entire package in your path, or just the sort.exe (and it dependancies:  libintl3.dll & libiconv2.dll somewhere in your path and use the command:

sort -S 3G -k 1,26 dataf -o dataf.sorted

[download]

(Note:This sort utility is a pre-compiled 32-bit binary, so 3 GB is the maximum it can handle)

The sort will be substantially slower than with the windows supplied sort, but should be quicker than your perl script.

With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.

The start of some sanity?

Replies are listed 'Best First'.
Re^6: external sort performance improved?
by rkshyam (Acolyte) on Apr 18, 2012 at 09:51 UTC

    I have installed coreutils and added path entry as mentioned.ran the command <1>sort -S 3G -k 1,26 sort_input.txt <2>sort -S 3G -k 1,26 sort_input.txt -o sort_output.txt but this is resulting in error "Input file specified two times"

[reply]

      Sounds like the Windows sort utility is appearing first in your path. You might consider renaming the coreutils sort.exe to (say) gnusort.exe.

      With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
      Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
      "Science is about questioning the status quo. Questioning authority".
      In the absence of evidence, opinion is indistinguishable from prejudice.

      The start of some sanity?
[reply]

        Hi BrowserUK. I have tested the sort functionality using coreutils. Time taken to sort in both methods are almost same(my earlier perl external sort took 32 mins and coreutils sort took 30 mins).

[reply]

      use absolute paths or manage your %PATH%, windows already comes with a sort utility

[reply]

In Section Seekers of Perl Wisdom