Forum: Ruby on Rails Avoiding filesorts in MySQL with tagging

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
8c49880a7f274947b01d576c5828a5f6?d=identicon&s=25 Lon Baker (spdemac)
on 2007-01-31 21:38
I recently started with implementing tagging using the various tagging
plug-ins and gems circulating.

All worked to some degree, but I found that the queries (has_many ->
through) that use any eager loading when coupled with order by clauses
tend to cause a lot of temp table creation and file sorts in MySQL.

Has anyone encountered this type of performance issue? If so, are there
any recommendations?
This topic is locked and can not be replied to.