[MariaDB discuss] Re: Speeding up a query: how to send 3 million rows faster?

В Tue, 31 Oct 2023 11:45:52 +0200 Vassilis Virvilis <vasvir@iit.demokritos.gr> пишет:

If you change the table format to MyISAM do you get better performance?

I almost missed your message, and that would have been a shame, because if I change the table format to MyISAM, I get the query results in ~3.5 seconds, which is faster than any other result I've been getting with MariaDB. Many thanks! This is the largest table in our database, but it's also the easiest to recreate, so we might just switch it to MyISAM with no apparent downsides. -- Best regards, Ivan