Re: Perl cleanup takes a long time

can you specify what you mean by "exit"? maybe a silly question, but the reason why i'm asking is that slurping in the data from the database and grouping them really won't take much time. but the ... 7 nested for loops by which you write the data to the text file, will probably really not be the fastest approach.

besides, doesn't SQL offer lots of means for the task you are performing? and for MySQL, if you /Tee your results to an outfile...?

--------------------------------
masses are the opiate for religion.

Comment on Re: Perl cleanup takes a long time

Replies are listed 'Best First'.
Re^2: Perl cleanup takes a long time by ChrisR (Hermit) on Jun 13, 2007 at 15:19 UTC
By "exit", I mean the `exit` command (the last line executed in the script). Slurping the data and looping for the file output is actually very fast (given that it may not be the fastest) considering the numbers of records I am looking at. And yes, you are correct in that MySQL has many ways of completing this task however it is not nearly as fast as perl. Chris Rogers www.pcewebs.com	[reply] [d/l]