This does not sound like a performance problem related to either the DBI or
DBD::Oracle. It sounds very much like an application optimization problem.
1. Did you trace your session with alter session set events '10046 trace
name context forever, level 8'? If so, send me the trace file.
2. Do you have a least one index on const_db whose first column is id? If
not, then create one and try it again.
3. Are you using the cost-based optimizer? If so, then maybe you need to
analyze the table and the index.
Jeff Holt
Chief Scientist, Hotsos LLC
mailto:[EMAIL PROTECTED]
+1.817.821.9553 tel
+1.413.480.7346 fax
http://www.hotsos.com
Join the Oracle Performance Revolution!
-----Original Message-----
From: Konstantin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 6:28 AM
To: [EMAIL PROTECTED]
Subject: very slow perl Oracle applicaton
Hi.
I have a Perl DBI application connected to Oracle database. In this database
there is a table called "const_db" which includes about 80 fields. After the
creation of this table, everything is working fine, but after I load 40,000
records using SQL*Loader, this application starts working extremely slow.
The parts of this application which have to call for a query "select * from
const_db where id=X" are working so slow, that the server deletes the
process before it ends. The most unclear thing is that even if I delete
those 40,000 records, the speed remains very slow.
Please help me.
Thank you very much,
Konstantin.
