Chris,
I would consider loading this script only once and establishing a single
connection to the DB server and then making it loop with a time delay
waiting for data to be inserted into the DB - that's pretty much what it
does, right?
The thing is that if you invoke the script every time you
econd, not per minute. So I would probably say the problem
is all in your select, which probably doesn't have an index or something.
Donny
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 8:04 PM
> To: [EMAIL PROTECTED]
> Subj
Hi Guys,
Iv got a script that iv been working on written in perl which interfaces to
mysql via the dbi module..
The script only does two selects within the entire script, so I didn't think
it would be too taxing on the machine.
Turns out that when the script is executed around 100 times a minute
