search

mathesar-foundation / mathesar

Web application providing an intuitive user experience to databases.
https://mathesar.org/
GNU General Public License v3.0
2.28k stars 316 forks source link

Very slow performance conducting basic database operations #3606

Open danielrosehill opened 1 month ago

danielrosehill commented 1 month ago

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 commented 1 month ago

@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: https://github.com/mathesar-foundation/mathesar/issues/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.