This would be nice if this was a ratings/comments list, but this is a
programming DBI list. Everything that you described below, we would need to
have in actual code, not necessarily the whole module, but snippets that
refer to the problem area. We can then comment on what is it you are doing
wrong and give suggestions. There should not big a big time difference in
SQLPLus Vs. Perl DBI, so it must be something in your code that is causing
it.
Ilya
-----Original Message-----
From: Phan, Robert
To: '[EMAIL PROTECTED]'
Sent: 08/02/2001 11:55 AM
Subject: Multiple select statements
I've been charged with the task of migrating our
current report generation program from sqlplus
to perl DBI. So far, all the scripts seem to work
well after I strip the formatting information out
of them with the exception of a few sql scripts.
After a little bit of digging, I noticed that all
of the faulty scripts have an embedded select statement
to aid with outer joins.
It should be noted that I am a perl coder, but the sql
scripts are supplied to me, and my knowledge of sql is
limited. The problems first arose with DBD::Oracle on
IRIX. So I migrated the system to Linux where the scripts
seem to function correctly, but take much longer than
they do from sqlplus.
sqlplus: 12 seconds.
DBI: 17 minutes.
This is unacceptable for production code.
Any and all help would be appreciated.
--
Bob Phan <[EMAIL PROTECTED]>
Neurogen Corporation
