It's not the SQL I'v already run SQL tests.
I think I found the problem, for some reason the my $dbh =
DBI->connect("dbi:Oracle:host=XXX;sid=XXX;port=XXX", 'XXX', 'XXX');
command seems to be causing the problem, if I change it to my $dbh =
DBI->connect("dbi:ODBC:oracledb", 'XXX','XXX'); there is a significant speed
increase. Could this be more of a connection problem than a code problem?I included all my code for the module incase there was something stupid that I'd missed, sorry to offend! > -----Original Message----- > From: Bob Showalter [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 2:23 PM > To: 'Grierson, Garry (UK07)'; [EMAIL PROTECTED] > Subject: RE: Why so slow!!? > > > -----Original Message----- > > From: Grierson, Garry (UK07) [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, October 03, 2001 9:07 AM > > To: [EMAIL PROTECTED] > > Subject: Why so slow!!? > > > > > > The following code runs very slowly compared to similar > > routines running on > > the same type of systems. > > > > Can anyone point out anything I'm doing that would make this > > particular code > > run slowly as I'm out of ideas! > > > > ...snip code... > > Until you can prove (to yourself and others) that your queries aren't > the "slow" part, you're not likely to get any help here. Test the > queries in sqlplus or whatever. If the queries are perfect, then remove > them from the code and hard-code some test data in. If it's still slow, > then come back here. Also, do some work yourself and strip out extraneous > junk and boil it down to the offending code. Nobody wants to slog through > dozens of lines of HTML boilerplate. > > Tuninq SQL is definitely not a subject for this list. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
