That said it's still 5-6x slower than without the library_id. The biggest difference between your library and mine probably is the number of contributors (12k vs 2k). If I don't join them in the query, we're down to 200ms...
...and with a few more tweaks (there are too many joins) I get the full query down to <100ms. Now I only have to figure out how to embed this in the code...
-- Michael _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
