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
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 12309Received on Mon Jan 05 1998 - 00:00:00 CET