Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hello, I'm a relative newbie. I have been asked by my organization to make a script to catalog the hours worked by the various members and make the output a huge table. The only way I have thought of would take a rather long time, but it would work. I'm worried though about the addition of more members. i only have a plain text file to store my records, no SQL database. What my script does is simply perform a long string of if and elsif statements, and I'm afraid that a large number of entries will make the script run too long and the server will discontinue execution of my script. Any suggestions?

Sincerely, A Worried Newbie

Replies are listed 'Best First'.
Re: Administration Troubles
by DamnDirtyApe (Curate) on Nov 13, 2002 at 06:12 UTC

    First off, you can use plain text files like SQL databases; take a look at the DBD::CSV module for more details.

    Second, it would be helpful to have more information about your problem. What precisely do you mean by "catalog"? Are you inputting these manually, or importing from another system? Just how much information do you need to track? A more detailed problem description would be helpful.


    _______________
    DamnDirtyApe
    Those who know that they are profound strive for clarity. Those who
    would like to seem profound to the crowd strive for obscurity.
                --Friedrich Nietzsche
Re: Administration Troubles
by rdfield (Priest) on Nov 13, 2002 at 10:48 UTC
    You could tie a hash to a file, for example DB_File

    rdfield