Browsed by
Tag: performance

Throttling Concurrent Outgoing HTTP Requests in .NET Core

Throttling Concurrent Outgoing HTTP Requests in .NET Core

In my last post, we implemented the rate limiting for an API endpoint on the server side. The server side rate limiting is useful for API providers to ensure system performance and/or to realize business values. On the client side, the API consumers then should throttle the rate of concurrent HTTP requests in order to comply with the rate limits of the endpoints and moderate the usage of client side resources. This post will go over how to make concurrent outgoing HTTP requests on the client…

Read More Read More

Bulk Processing with BULK COLLECT and FORALL

Bulk Processing with BULK COLLECT and FORALL

Source: https://blogs.oracle.com/oraclemagazine/bulk-processing-with-bulk-collect-and-forall In the previous article in this series, I introduced readers to PL/SQL collections. These data structures come in very handy when implementing algorithms that manipulate lists of program data, but they are also key elements in some of the powerful performance optimization features in PL/SQL. In this article, I will cover the two most important of these features: BULK COLLECT and FORALL. BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data…

Read More Read More