Oraperl / DBD / Perl5 Performance for Oracle query?

From: Mark Kornfein <kornfein_at_.crd.ge.com>
Date: 1998/01/05
Message-ID: <68r3rr$6hv$1_at_rdsunx.crd.ge.com>#1/1


[Quoted] I've recently come on board a web project that uses the Oraperl emulation interface for DBD. The performance is horrible, a query that returns in 4-5 seconds from sqlplus takes 50 seconds, This is just to do the "fetch" without calling any cgi scripts.

The documentation hints at a "cache value" that one can set but then goes on to say that it not implemented yet. I should point out that the query is trival and just brings back a lot (about 1000) small rows (1 field) from Oracle.

I think we are using the latest version of the emulation (I think DBD version 0.90).

Any ideas?
Is this a known problem with the DBD - Oraperl emulation? Any workarounds?

thanks,

Mark

-- 
===============================================================================
Mark Kornfein                              INET: kornfein_at_crd.ge.com
GE Corporate Research & Development        Phone: (518) 387-5843
One Research Circle, K1-5B36, Schenectady, NY 12309                         
Received on Mon Jan 05 1998 - 00:00:00 CET

Original text of this message