nadeeshaan/JGSoC-SQL-Optimisation — pull request #11 by nadeeshaan (2014-07-09 06:08:21+00:00)
Title: Added index idx_published_ordering to language table

In this pull request I have added an index for the language table to improve the performance of this query

SELECT *
FROM #__languages
WHERE published=1
ORDER BY ordering ASC