Re: DBD::Oracle question?

On Mon, Feb 26, 2007 at 12:32:21PM +0200, Eugene Krivdyuk wrote:
On 2007/02/26 Mon 02:20:25 , rami doqa wrote:
Hi ALL. Is there a relation between the version of
DBD::Oracle and Oracle 10g.
The performance of executing the SQL statements is low
comparing to mysql performance.
Can any body advice me what to do to avoid this
performance issue

What DBD::Oracle version are you using ? Performance issues may be caused
by incorrect Perl code, bad server configuration, network problems, etc.

Can you post your Perl code here ?

Ideally as a very small self-contained example that other people can run.
Include the table definitions and server hardware and software config info.
(Also read http://www.catb.org/~esr/faqs/smart-questions.html)

Tim.

p.s. To anyone thinking of commenting on this thread, please avoid
knee-jerk statements like "Oracle is bound to be slower than MySQL."
.

Relevant Pages

  • Re: performance questions and help!
    ... The last link provided by Robert Klemme is the Oracle 10g R2 ... you a different execution plan than what was actually used when the ... using bind variables is usually better than specifying ... constants in the SQL statements. ...
    (comp.databases.oracle.server)
  • Re: Does Optimizer use P.A.T to calculate cost..?
    ... hints to the SQL statements to essentially force Oracle to use index ... I want to move away from using the 'old' method of manually specifying ... Some of those SQL statements that I brought over ... likely resulting in multi-pass sorts. ...
    (comp.databases.oracle.server)
  • Re: Modelling objects with variable number of properties in an RDBMS
    ... >> Oracle supports maximum 1000 columns. ... > I have a set of SQL statements suitable for IBM Informix Dynamic Server ... > the only limit out there - there are higher limits. ...
    (comp.databases.theory)
  • Re: Does Optimizer use P.A.T to calculate cost..?
    ... Scan through the trace file and look for the wait events ... I rely on NOWORKLOAD system statistics - the default behaviour. ... hints to the SQL statements to essentially force Oracle to use index ... Some of those SQL statements that I brought over ...
    (comp.databases.oracle.server)
  • Re: Does Optimizer use P.A.T to calculate cost..?
    ... Scan through the trace file and look for the wait events ... I rely on NOWORKLOAD system statistics - the default behaviour. ... hints to the SQL statements to essentially force Oracle to use index ... Some of those SQL statements that I brought over ...
    (comp.databases.oracle.server)