Good day ANZ,
I'm having quite an issue with the API timing out the whole time when trying to do a sync local database on xamarin. The local db works fine and general connection speed is also fine.
The basic amount of data that I am trigger a get for is around 100-200 info rows at a time. This is roughly 10-20 columsn of data per line.
The GetAll keeps timing out and I have tried adding UnitOfWork as well to it, not sure if this helps for get all API calls as well.
I need to be able to pull atleast 1000 records without a timeout trigger, I split it up in smaller calls anyways so the volume is lower. So 100-200 should be fine but timeouts are the main issue regardless of what I try. It is already timing out at around 55 roecords.
How can I adjust the timeout or get the data in a better way over the API to enhace the speed?
Test where performed after restarting IIS pools/sites and the SQL server itself. In short a clean remote test.
Any help on this will be greatly appreciated.