Faster, more efficient execution

In this version of SQL Navigator, we have taken a number of measures to streamline the execution of basic functions. One of the most significant is the use of internal cache for all operations that retrieve data from the Oracle data dictionary. This saves time and extra processing cycles. Other engineering improvements include the following:

 sharing data between connections to the same database/user name

 using bind variables wherever possible instead of dynamic construction of SQL in internal queries

 reduced polling of the database by using blocking mode combined with multi-threaded execution instead of non-blocking mode and a single thread

 an improved method of storing query results that takes one-fifth as much memory as the previous version

 limiting the loading of object lists, such as the list of stored programs in the Stored Program Editor, to instances where the user explicitly requests access to the list