> -----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]
