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

Hi, I have to write a perl script which has to access database in every fifteen minutes to fetch around 50k records in every hit. Will the perfromance be affected?if increase of hardware help to overcome that, its alos possible.BUt how can i know how much more hardware i need?

Replies are listed 'Best First'.
Re: perl database access
by Corion (Patriarch) on Jun 23, 2009 at 14:17 UTC

    This really, really depends on the database, the query, the size of the table, the indices on the involved tables, the existing load of the machine and the database in question, and the hardware and network configuration of the database server and client. You haven't provided any of that, so it's hard to give you a meaningful estimate. For a rough estimate, I would set up a secondary machine, restore a backup of the database on it and run some benchmarks or contact the presales consultants of some of the database vendors.

[reply]
Re: perl database access
by moritz (Cardinal) on Jun 23, 2009 at 14:20 UTC
    You can know by trying it out, and see if it works. If the machine can't handle it, you optimize and/or buy more hardware.
[reply]

Back to Seekers of Perl Wisdom