At 11:21 16/07/2001 -0700, Randal L. Schwartz wrote:
> >>>>> "Ingram" == Ingram <[EMAIL PROTECTED]> writes:
>
>Ingram> What I would like to know is there any way to increase the efficiency
>Ingram> of my code, or are there any other ways to accomplish such a task in a
>Ingram> more efficient / optimised manner, through core Perl code or modules
>Ingram> etc. (I have looked and there don't seem to be any to manipulate array
>Ingram> in this way), also there is no reference to any such techniques in any
>Ingram> books I have or any perldoc such as perfaq4. When running the present
>Ingram> code over many thousands of @one items it starts to take an awful long
>Ingram> time and causes big server slowdown, which is a prob as I need to call
>Ingram> this from the Web for a real-time reporting CGI on a internationally
>Ingram> busy Web server so there are no quite periods where I could run a cron
>Ingram> without affecting server performance.
>
>"Thousands of items" sounds like it's time for a Real Database. I'm
>recommending PostgreSQL for all my new installations.
thanks - I'll look into PostgreSQL (never tried it before). This script is
only a stop gap measure before the already started DB upgrade of the well
outdated text file based system, however a foul up in timescales has led to
the admin dept. implementing a new invoicing system before the dev dept.
have had a chance to finish all relevant upgrades - hence the need for this
script! - typical!!!
>--
>Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
><[EMAIL PROTECTED]> <URL:http://www.stonehenge.com/merlyn/>
>Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
>See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
>
>--
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
