Recently I came across a fascinating engineering challenge. The challenge is about adding a new column to a table and updating its value. But the main catch here is the table includes 1 billion records.
I think your solution has a bottleneck at the step where it calls the UTR API. Regardless of what you do before calling the API, it is still limited by the rate limit. Can the UTR API return a list if we input a list of transaction IDs?
I think your solution has a bottleneck at the step where it calls the UTR API. Regardless of what you do before calling the API, it is still limited by the rate limit. Can the UTR API return a list if we input a list of transaction IDs?
Yes it can. But for the problem statement I got UTR API was not returning list. If it returns list than we need to care about database transactions.