|
|
|
|
|
|
by kenn
3998 days ago
|
|
|
It would be slow on MySQL, though. If you EXPLAIN that query, it's a DEPENDENT SUBQUERY which has to fetch N*M records. It would be mitigated if the columns are property indexed, but two separate queries (N+M) just as eager loading would be faster and more predictable than nested scans in terms of IOPS. |
|
|