Re: Load Testing Script
have you looked into sqlldr Robert Hicks [EMAIL PROTECTED] wrote: Garrett, Philip (MAN-Corporate) wrote: Robert Hicks wrote: Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might have a better script... Have you tried the Benchmark module? It's in the Perl core. - Philip That really doesn't load test but yes I am using it in my script. I get something like: 5 inserts in: 39 wallclock secs ( 8.60 usr + 1.23 sys = 9.83 CPU) 5 selects in: 76 wallclock secs (48.34 usr + 8.08 sys = 56.42 CPU) Robert
RE: Load Testing Script
Robert Hicks wrote: Garrett, Philip (MAN-Corporate) wrote: Robert Hicks wrote: Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might have a better script... Have you tried the Benchmark module? It's in the Perl core. That really doesn't load test but yes I am using it in my script. I get something like: 5 inserts in: 39 wallclock secs ( 8.60 usr + 1.23 sys = 9.83 CPU) 5 selects in: 76 wallclock secs (48.34 usr + 8.08 sys = 56.42 CPU) If you're looking to really load test your database, you can use (gasp!) JMeter's jdbc sampler. Of course that means you can't use your Perl modules... - Philip
RE: Load Testing Script
Hey Robert, Are you going from Oracle to Oracle? Peter -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 7:52 AM To: dbi-users@perl.org Subject: Load Testing Script Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might have a better script... Robert This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
Re: Load Testing Script
Loo, Peter # PHX wrote: Hey Robert, Are you going from Oracle to Oracle? Peter Yup...I am basically wanting to test against 1 particular Oracle db. Robert
RE: Load Testing Script
From a flat file? Peter -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 9:47 AM To: dbi-users@perl.org Subject: Re: Load Testing Script Loo, Peter # PHX wrote: Hey Robert, Are you going from Oracle to Oracle? Peter Yup...I am basically wanting to test against 1 particular Oracle db. Robert This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
RE: Load Testing Script
Robert Hicks wrote: Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might have a better script... Have you tried the Benchmark module? It's in the Perl core. - Philip
Re: Load Testing Script
It probably doesn't matter. Right now I just have a script that does inserts and selects. I control the database so I can do pretty much what I need to do. Loo, Peter # PHX wrote: From a flat file? Peter -Original Message- From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 9:47 AM To: dbi-users@perl.org Subject: Re: Load Testing Script Loo, Peter # PHX wrote: Hey Robert, Are you going from Oracle to Oracle? Peter Yup...I am basically wanting to test against 1 particular Oracle db. Robert This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
Re: Load Testing Script
Garrett, Philip (MAN-Corporate) wrote: Robert Hicks wrote: Does anyone have such a beast for Oracle? I am trying to eliminate the Perl/DBD::Oracle side of the equation for some problems in our app. I did a looping select 20,000 times and the same for an insert. I thought that someone might have a better script... Have you tried the Benchmark module? It's in the Perl core. - Philip That really doesn't load test but yes I am using it in my script. I get something like: 5 inserts in: 39 wallclock secs ( 8.60 usr + 1.23 sys = 9.83 CPU) 5 selects in: 76 wallclock secs (48.34 usr + 8.08 sys = 56.42 CPU) Robert
