Unbelievably slow

[step135]

I created one document of two fields for all database and it takes each time 3 seconds to retrieve it. What's wrong!?

[benallfree]

@step135 I'll need a lot more info to troubleshoot this. Please join us on Discord https://discord.com/channels/1128192380500193370/1128192380500193373 if you are able, your questions will be answered faster.

Otherwise, please post an HTTP GET example here.

[step135]

I found on Reddit other people complaining about the same and having the same performance. It looks like you serve the data from far away Europe. But still it doesn't explain those 3 seconds (consequence of OPTION and GET requests, each of them 1.5 seconds).

[benallfree]

Could you provide the Reddit link please?

Also, please provide the HTTP GET in question.

Latency is complex and is discussed often on Discord. Just today, someone was reporting 1s latency while someone else in the same country was getting 200ms just like I was.

[step135]

GET https://{xxx}.pockethost.io/api/collections/posts/records?page=1&perPage=500&skipTotal=1&sort=-created

1s latency is a lie, it can never be achieved with any service !!!

[benallfree]

Nobody can help you until you will provide a valid URL.

[lukepighetti]

Hey there, I know this isn't enough info to do a full repro but I am seeing some pretty alarming latencies and 429s on an app that is trying to do batch inserts. When the insert returns 429 the admin panel stops responding for about 30 seconds. In my case I'm checking if a record exists (with a unique field) before creating a record(5 columns, < 20kb in size). I'm doing this about 100 times in 30 seconds and getting throttled.

[lukepighetti]

I was also seeing 15 seconds or more latency on authentication requests

[benallfree]

429 means you are hitting a rate limiting error which is currently 50 requests per 10 seconds per IP. Please move over to https://discord.gg/nVTxCMEcGT for better support :)

[lukepighetti]

appreciate the info and thank you for the discord link. What's the recommended way to do bulk inserts remotely?

[benallfree]

https://www.npmjs.com/package/bottleneck 💪

[lukepighetti]

awesome... thank you!