Very slow performance conducting basic database operations

[danielrosehill]

Just curious to know whether anyone else is experiencing this / it might be a known bug.

Reading, writing columns and rows has a noticeable lag for me but working with the database through a conventional frontend like Dbeaver is fine.

Anything work trying?

[kgodey]

@danielrosehill This is a known issue, and it's the biggest priority for our upcoming beta release (which will be Mathesar's next release, coming in a couple of months). You can track our progress here: #3516

Eliminating network latency between Mathesar and the DB (i.e. hosting connected DBs on the same server) will be faster, if that's an option for you. But unfortunately there's no quick fix, we made non-optimal technology choices for the initial development of the project which we're in the process of replacing.