Hello. I have percona server 5.7 and SQL query something like: SELECT (SELECT count() FROM table2 WHERE id=t1.t2_id) as query1, (SELECT count() FROM table3 WHERE id=t1.t3_id) as query2 FROM table1 t1 ORDER BY query1 desc, query2 desc, t1.id desc With order by I have execute time: 54sec, with…

Speeding up sort with subquery?

Alexandr_Krilof January 20, 2017, 3:21am 2

Any idea? Thanks.

Topic		Replies	Views
Join and order performance across two tables after switching from MySql Other MySQL® Questions	3	540	July 19, 2017
Slow query on Percona 5.6.14 (please help) Other MySQL® Questions	0	733	November 6, 2013
MySQL vs MariaDB - "Using sort_union(index1,PRIMARY)" MySQL & MariaDB mysql	2	275	June 12, 2024
Slower than expected primary key based query Percona Server for MySQL 8.0	4	722	May 11, 2019
Performance Tuning for InnoDB? Other MySQL® Questions	2	549	December 15, 2011