Acumatica endpoint taking too long to return records

That's a lot of records to pull in each time.   Can you use a GI instead to reduce the amount of data or require entering at least 3 characters for example before sending the request so it's filtered?  

Hi @Michael Ndungi 

Depending on your needs, you could try using $select to limit the fields returned for each record.

For example, something like this should dramatically reduce the amount of data returned (and by extension, the time taken to process the request):

https://XXX.acumatica.com/entity/Default/20.200.001/Customer?$select=CustomerID,CustomerName

I’ve also heard that GI based OData feeds tend to run faster than the WS API.

Thank you @bryanb39 

I used a GI to retrieve the records, the response time improved slightly, however, the user has to wait for like 2min to get the list of all customers and I’m only interested in only 6 fields.

could you please elaborate abit on the following statement?
“or require entering at least 3 characters for example before sending the request so it's filtered”

Thanks @stephenbologna39 

I I’m using $select to limit the fields to only 6. However, The time taken to return response is still too long.

Do you have an example or article I can reference on this?
“I’ve also heard that GI based OData feeds tend to run faster than the WS API.”