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/

.. drwxr-xr-x
ui/ drwxr-xr-x files
404.html 305 -rw-r--r-- file | revisions | annotate
500.html 305 -rw-r--r-- file | revisions | annotate
atom.xml 950 -rw-r--r-- file | revisions | annotate
base.html 2066 -rw-r--r-- file | revisions | annotate
check.html 3156 -rw-r--r-- file | revisions | annotate
compare.html 1138 -rw-r--r-- file | revisions | annotate
dot.svg 123 -rw-r--r-- file | revisions | annotate
index.html 361 -rw-r--r-- file | revisions | annotate
project.html 2278 -rw-r--r-- file | revisions | annotate
status.svg 970 -rw-r--r-- file | revisions | annotate