ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Did v11 do anything to improve MariaDB performance? (or os that in v12?)


#1

I remember reading a thread (that I can no longer seem to find) where there was a discussion about tuning MariaDB to reduce the CPU time that it uses and improve it’s efficiency.

I also thought I remembered that part of that thread talked about integrating the improvements into the next version. This has been in the past 5 or 6 months that I remember reading all of this on the forum here.

Can anyone from the development team tell me if the improvements made it into v11?

The reason I ask is that I have a client using v10 and their database is quickly approaching 2gb in size and I would be looking to move them to a new version once I know there is going to be a performance benefit for the database.

Thanks,

BKM


#2

Perhaps you refer to this [Performance] 1 Sales Invoice Save makes ~700+ DB calls. ~1000+ DB calls on Submit

What PR corresponds to this, to trace and confirm the above refinements to caching and/or reduced calls to the database, is the question?

I don’t think database size affects performance. MySQL can handle terabytes! However individual tables can grow large that may require indexing, but I am no expert.


#3

You are partially correct. There was in fact another thread after this as rmetha indicated should happen before he closed the thread in your post. It is the follow up thread that I was trying to find. In it a developer had indicated he was going to make a PF for it.

BKM


#4

I think I might have stumbled upon it:


#5

You are correct! that was it.

And searching the PRs, it appears it was never done. So I guess we may never know if the core devs took it upon themselves to do something similar. I didn’t see anything in the release descriptions.

Thanks for remembering and posting back.

BKM