[thesite] Tip Harvester question (was: [***] Formatting tips )

[Dean Mah]

Without resorting to PL/SQL you may want to investigate some of the
following to see if performance can be improved.

I know that in some languages, e.g., Perl and C, you can use bind
variables to speed up queries.  Oracle can cache the SQL in its SGA
and the do a variable binding/substitution just before execution.  In
Perl I've seen 50 times speed up on frequently executed queries.

Also, connects/disconnects in Oracle are extremely expensive
performance-wise.  Ensure that you are only connecting once to Oracle
and then doing all of the queries and then disconnect.

You may also want to turn off auto-commits.  If you are commiting
after each query, Oracle needs to write the transaction to the
redologs each time.  Of course, this means that your rollback segments
must be large enough to contain all of the uncommitted data.

Dean