Is there some way to coax the “oracle8” connector into supporting array fetch? I want to fetch multiple rows of data with a single call, using multi-value LCFieldlist objects, as documented in the “Multiple Row Operations” section of Chapter 1 in LSX for Lotus Connectors.
I’m looking at an ADDM report for my Oracle database that’s telling me the #1 problem child query is coming from Lotus Notes. The recommendation from the ADDM report is “Use bigger fetch arrays while fetching results from the SELECT statement”. (The reality is the SELECT statement is suboptimal in more ways that one.)
I’ve tried changing my code to bring back multiple records with results = connection.Fetch( fields, 1, 50 ), but as far as I can tell, the oracle8 connector still making one call to Oracle 11.2.0.4 for every row in the result set.
Support for “array fetch” in the oracle8 connector appears to be undocumented.