Baserow is slow for POST / UPDATE / DELETE

[emmanuelgutman]

Hi all !
I've been using Baserow on Cloudron since 5 months now. I'm currently using a very slow Baserow :

• Directly from the visual tables, it is slow to create or delete rows (sometimes, it can take 20 seconds, and not work at all)
• API Calls are sometimes very long (POST / UPDATE / DELETE), and they sometimes respond with error 500 or network error.

My current setup :
Digital Ocean Droplet - 4 GB Memory / 25 GB Disk (Frankfurt) - Cloudron 7.6.2 on Ubuntu 22.04
Cloudron, easily installed with DigitalOcean Marketplace
My Cloudron runs two apps :

• Baserow
• n8n

At the moment, I run 1 database and it isn't so big :
15 tables in total
300 lines in TOTAL in my whole database
Quite a few columns (3 tables have more than 40 columns)

I don't really understand because my database is still pretty tiny and the ressources shown both in Cloudron & DigitalOcean do not seem to indicate any big trouble ... so it is hard to debug!

Here are a few screenshots to help :

From DigitalOcean Cloudron Droplet

From Cloudron interface

From Cloudron Services tab

And from Baserow app ressources

Any idea where that might come from?

Thanks a lot,
Emmanuel

[girish]

@emmanuelgutman I would give postgresql say 2GB memory. Because of a quirk, only 50% gets allocated as RAM in Cloudron (this is changing in Cloudron 8).

Also, I wonder why mysql and mongodb are down. Have you tried restarting those services? Maybe constant restart is consuming some CPU?

[parhelium]

Hi,

I have just tried to update column from text to formula for 1244 rows .
It is impossible, as it takes for Baserow more than 20sec, so 502 error is thrown.

My setup:

@girish
Is there a way to configure cloudron to allow for requests longer than 20 sec?

[girish]

@parhelium said in Baserow is slow for POST / UPDATE / DELETE:

It is impossible, as it takes for Baserow more than 20sec, so 502 error is thrown.

Do you mean it is taking baserow more than 20 seconds to query the database and thus it returns a 502 ?

[parhelium]

@girish yes

Is there a way to define timeout per app ?
Complex queries could take more than 20 secs in Baserow

[girish]

@parhelium this might be a baserow setting. The statement_timeout is not set in postgres and the default is 0 which means no timeout.

You can also double check this by running the postgres command via the Web Terminal . Does the query take more than 20 secs but succeed anyway?

[parhelium]

@girish I believe it is cloudron issue, because after 20sec I see in response:

[girish]

@parhelium that page is shown when there the app is not responding. It doesn't necessarily tell us where the issue is.

Is there nothing in the logs indicating what baserow is doing ? BASEROW_BACKEND_LOG_LEVEL can be set to higher level (https://baserow.io/docs/installation/configuration) to get more logs. If you are 100% sure it is database related, have you tried running postgres command directly on the web terminal to reproduce ?

[emmanuelgutman]

So I have gave 2Gb Limit to Postgresql, but nothing apparent changed. Also as Baserow is running on Postgres I disabled the containers of MySQL and MongoDB from DigitalOcean CLI. That was probably three months ago and it was perfectly normal so far...

In some tables (not all of them, it seems to depend on the number of computed columns) the rows are very slow to create.

For instance, in the last table I created, about two weeks ago, there are in total 30 rows, 25 are computed. I cannot create a single row, the request or something takes too long.

[girish]

@emmanuelgutman We have to debug further to understand what is going on. If you can contact us on support@cloudron.io , we can take a look to see if this is some Cloudron issue or Baserow issue.

[girish]

This had to do with the server being just a 2core CPU. A slightly faster server fixes the problem.

[necrevistonnezr]

@girish said in Baserow is slow for POST / UPDATE / DELETE:

This had to do with the server being just a 2core CPU. A slightly faster server fixes the problem.

As we had quite a few topics covering too slow CPUs or too little harddisk space recently - maybe it makes sense to raise the minimum requirements in https://docs.cloudron.io/installation/? Or at least put a caveat that, depending on the apps, the server easily requires a multiple of the current requirements?
It seems to me that users believe one can run Cloudron and 10 resource-heavy apps on 2GB RAM, 20GB Disk space as currently described in the docs....
Or add some recommended requirements based on past experiences?

[girish]

@necrevistonnezr we get many users from the marketplaces who skip the docs altogether. Even putting some checks and warnings in install script doesn't help in those cases. Not sure what can be done, but I have started putting and more checks into our new --troubleshoot script Let's see.

[necrevistonnezr]

Aho, I understand.

I - unsuccesfully - tried to edit the index.md in https://docs.cloudron.io/installation/. I get an error "a file with this name does not exist"...?

Anyway, add something like:

_(Note: ressource heavy apps easily require a multitude of these values - requirements for each app are mentioned in the app store)_.