Re: how would you suggest to optimize theese quries?
Without error trapping and error handling in connect, query and fetch calls, you have a house of cards. First thing I'd do is build in error trapping & handling.
It does appear you could collapse that sequence of queries into a smaller number of queries. Would the performance gain be worth the effort? I don't know---how slow is the script as is?
Subject
Views
Written By
Posted
619
November 29, 2021 11:26AM
Re: how would you suggest to optimize theese quries?
321
November 29, 2021 12:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.