3 Performance Tricks for Dealing With Big Data Sets
DZone
AUGUST 21, 2021
This article describes 3 different tricks that I used in dealing with big data sets (order of 10 million records) and that proved to enhance performance dramatically. Trick 1: CLOB Instead of Result Set. The use case here was that I had a big database table (~ 10 million records) that I need to query on one column in it, but need to eventually get all data inside it, imagine a table containing millions of customers and in one use case, you need to get the mobile numbers (MSISDN) of all of them a
Let's personalize your content