[MariaDB discuss] Re: Troubleshooting major performance issue.

On Mon, 24 Mar 2025 at 18:57, Olivier Miquel <olivier.miquel@mri.cnrs.fr> wrote:

Yes you're right! Sorry, i had swapped the two results. It is way slower with 10.11.

I could add an index on recipient, but why this is so faster with 10.3 without any indexes ?

What do you get from: ANALYZE select count(recipient) from transactions;

I'm guessing that there's something i missed here.

Same disks, same file system? -- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net