Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^2: Speed up perl code

by cibien (Novice)
on Oct 09, 2012 at 15:09 UTC ( #998024=note: print w/ replies, xml ) Need Help??


in reply to Re: Speed up perl code
in thread Speed up perl code

The script is writed by hand. thank you for your very esauxtive answer. I have used your adwice, but I understand that it speding a lot of time here:

 while( ($filename = readdir(DIR))){

the module Spreadsheet::ParseExcel spend a lot of time to open the excel file... Is fast to open light .xls files, and very slow to open big (more than 4mb) .xls files I think is nothing to do. anyway thankyou very much


Comment on Re^2: Speed up perl code
Download Code
Replies are listed 'Best First'.
Re^3: Speed up perl code
by Anonymous Monk on Oct 09, 2012 at 19:22 UTC

    Yes, it is spending much time in that loop, because 90% of your code is there.

    You need to divide your code into subroutines, preferably small ones, to get a reasonable analysis from a profiler.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://998024]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (10)
As of 2015-07-30 00:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls