306:edefddec933d
Anton Shestakov <av6@dwimlabs.net>, Sun, 24 Sep 2017 12:25:05 +0800
viewer: use subqueries to get data on index page Before, there were bare columns in the aggregate query, their values were undefined (but it somehow worked), as SQLite docs say. Good news is that now this bigger query uses (project_id, ordinal) index and is really fast.

/templates/ui/

.. drwxr-xr-x
badges.html 746 -rw-r--r-- file | revisions | annotate
check-log.html 714 -rw-r--r-- file | revisions | annotate
checks.html 796 -rw-r--r-- file | revisions | annotate
codes.html 1668 -rw-r--r-- file | revisions | annotate
pagination.html 188 -rw-r--r-- file | revisions | annotate
project-link.html 228 -rw-r--r-- file | revisions | annotate
time.html 69 -rw-r--r-- file | revisions | annotate