How to optimize this low-performance MySQL query?
Hi there, I’m currently using the following query for jsPerf. In the likely case you don’t know jsPerf — there are two tables: pages containing the test cases / revisions, and tests containing the code snippets for the tests inside the test cases. There are currently 937 records in pages and 3817 records in tests. As you can see, it t...