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
