Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
||
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
I have a data warehouse. To return the first few rows takes 1 second. However, I I want to get all the rows, and it takes about 30 min. What can I do to speed this up?
That depends on where most of the time is spent: (1) fetching rows from buffers, (2) transmitting them to the client, or (3) processing them on the client.
The first thing to do is figure out which one is the biggest contributor to response time and then list your possible solutions by their implementation cost. |
Powered by FogBugz