Slow with Cockroach
At some point in one of the later updates everything got very slow. Opening a new connection to the Database takes 10-20 seconds, opening a table in view takes 5-10 seconds. Making a small change in the table and committing that change can take 60 seconds, even if the table is a tiny table w/ 3 rows.
Sorry don't have much more info to provide, maybe you can reproduce it easily?
Hi, thank you for the feedback. Do you connect to the database directly or using SSH (and latest release, are you using the build 114)?
@huyphams directly (over vpn). In prior versions it was fast, I cant remember what version things changed. Do you have a test db? Honestly if you connect to it and add a row to an empty table you should be able to reproduce it.
I don't think it's a network issue on my end, I've done some other testing to rule that out.
@huyphams found an old build on my pc, build 85, works really fast. Hope that helps.
I didn't change the core, which is handling the connection. but let me take a look at it.
I have this problem with a PostgreSQL database via Wireguard VPN, but the tables are larger (to be excact, we use views), the loading takes mulitple minutes to sometimes "infinite".
What I often see then is this:
On local/ssh directly connections I dont have this issue.