414 Request Status - Too large Request URL
I have a column with a big array that consists of cached IDs (on the 1st screenshot). I get values from it. And use these values to get records from another table that haven't cached.
In other words, after getting a big array values I fetch records from another table with a condition: if the column value is not in that big array (means it hasn't been cached).
Part of request looks this way:
So it's too big. How could I fix that? I have no options:
1. This array represents cached values
2. I must only show user the data that hasn't seen previously (means not in that big array of cached values)
3. Then it means that I could only fetch with a filter that basically says COLUMN not in (a lot of IDs). Request is going to be huge anyways.
In other words, after getting a big array values I fetch records from another table with a condition: if the column value is not in that big array (means it hasn't been cached).
Part of request looks this way:
So it's too big. How could I fix that? I have no options:
1. This array represents cached values
2. I must only show user the data that hasn't seen previously (means not in that big array of cached values)
3. Then it means that I could only fetch with a filter that basically says COLUMN not in (a lot of IDs). Request is going to be huge anyways.
