Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

[Øystein Grøvlen]

Hi,

AFAICT, you can use an IN-subquery for this. Something like:

SELECT id, nome FROM radcliente t WHERE t.id IN
(SELECT cliente_id FROM radacct WHERE nasipaddress='...') LIMIT 10;

And make sure to use MySQL 5.6. It has better performance of IN-subqueries than earlier versions.

Hope this helps,

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway