We have it working were we call an Oracle package and return the result set in a TOracleQuery. Only problem is it is very slow.
There are about 15,000 rows to be returned. The first query (for the package itself) returns in about 30 seconds. The second query (for the cursor) takes over 1 minute to complete the "Execute" call.
My question: Is there anything I can do to speed it up? I've noticed that during these 2 execute calls that my CPU is at 0% and the network traffic is also at 0%. After the second query returns then my machine gets busy processing the results.
There are about 15,000 rows to be returned. The first query (for the package itself) returns in about 30 seconds. The second query (for the cursor) takes over 1 minute to complete the "Execute" call.
My question: Is there anything I can do to speed it up? I've noticed that during these 2 execute calls that my CPU is at 0% and the network traffic is also at 0%. After the second query returns then my machine gets busy processing the results.
