Bug: Massive performance degradation on v1.4.2

[tcm151]

Describe the bug

I have a small instance running on a Linux box hosted by Linode. I supports the backend for my blog and a couple other side projects. I recently updated to v.1.4.2 and the performance dropped off a cliff, I was going from 30-80ms response times to well over 1-3s response times for the exact same query. The surreal.exe was also using 99% of my CPU time compared to about ~2-4% regularly

Steps to reproduce

1. Install v1.4.2
2. Install v1.3.1
3. Compare on Ubuntu Linux

The repository of my blog which can be run standalone quite easily

Expected behaviour

The performance drop off here is definitely not intended.

SurrealDB version

surreal 1.4.2 for linux on x86_64

Contact Details

tylermckay10@gmail.com

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct

[sgirones]

thanks for the report @tcm151 .

Could you provide an example of a query that experienced this perf degradation? Maybe we can easily spot the code change that caused this.

[EMUNES]

I have the same problem on Win11. The obvious thing is that after running surrealdb 1.4.2 for some time, my PC CPU and memory usage will be very high. And then my computer will be very lagging. Things will go back to normal if I stop surreal.exe.

[drunkplato]

Same thing for us. We had a large query that was sub-second and now is 5 - 6 seconds. Performance is still an issue in 1.5.0.

Downgrading to 1.4.0.