Have Geek Brain

Using PL / SQL, what are the good possibilities for sending large amounts of data to client code?

Using PL / SQL, what are the good possibilities for sending large amounts of data to client code?

To develop, PL / SQL on the server side runs on demand and generates a data-heavy response that needs to be sent to the client code. Are there "good options" for sending large amounts of data? What types of Oracle advantages / disadvantages are important to consider here?

0


a source to share


2 answers


Two problems that arise when you want to return large amounts of data:

  • bandwidth problems.
  • memory problems (both on server and client)


If possible, you should try to pass data, rather than return it immediately. You will occupy the same bandwidth, but there is less peak usage and you prevent memory problems (at least on the server, it depends on your client implementation, how memory is used there).

Oracle provides support for streaming through pipelined functions . You can find examples here and here .

+1


a source


there are no good parameters, always try to send the client the minimum amount of data. your database and network will thank you!



if you can send small chunks over time, it would be better to dump everything at once.

0


a source






More articles:


All Articles