Regular timeouts for custom JS cloud code heavily using the DB

Server Code
1

Hey guys,

since the “we are updating backendless” message in the Console website appears, we are constantly getting timeouts of our custom JS business logic functions.
All database requests are very slow (about factor 10). Where previously API endpoint with a single DB query needed ~ 400ms, we are now very close to the 5s.
Other API endpoints where we are doing 5 DB queries time out constantly…
Our code was not changed since the last wheek, where everything worked fine.Are you aware of these performance issues? Can I do anything on my side?
Our app ID is: 63087FF7-7E1D-973D-FF3B-D5F0740FA100

Thanks in advance

2

In the meantime I found out, that all requests using relations are causing problems. If I remove the relations list and set the relations depth to 0 in the query builder, then it is as fast as last week.

3

I changed now all database queries not to load any relations and do it afterwards with extra queries and fill the related data into the fetched data list…
Not that nice, but seems to be even faster that it was before when loading with relations didn’t cause timeouts.

Just to be clear: This is no general issue with relations! It happens only with big page sizes > 50) and in some tables.
When I e.g. load users with 2 relations and depth 1 it still works fine.

4

Hello, @jonas-eberhard.

We are considering your problem. We will let you know when there are any results.

Regards, Nikita.