I am working on a marketplace with a number of different query parameters. I currently have it setup so that each time a parameter is changed in any field, the API runs again to get the updated list of items. I have a couple questions with this.
Is this best practice? Will this overload my API at some point (lets assume this website will be extremely successful someday lol)?
Would it be better to pull a lot of data and then filter it further with a Show formula or something?
I am currently only pulling the first 10 records, but will eventually setup pagination and/or load more on scroll, so I won't grab everything at once ever. Total records are going to max at about 3000 with 50 columns, though the API doesn't grab all of the columns ever, really.
I suppose my question boils down to API call Mass/Volume vs API call Frequency.
Thanks!
.jpeg/public)