summaryrefslogtreecommitdiffstats
path: root/releng
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2012-11-20 15:57:05 -0600
committerDan McGee <dan@archlinux.org>2012-11-20 18:17:48 -0600
commit160a08bba5324b25abd9e866b884c91d75e597b0 (patch)
treef1e6dd7cd724a584682970fa43cfdcba0b54ca40 /releng
parent9e9157d0a8cbf9ea076231e438fb30f58bff8e29 (diff)
downloadarchweb-160a08bba5324b25abd9e866b884c91d75e597b0.tar.gz
archweb-160a08bba5324b25abd9e866b884c91d75e597b0.zip
Improve performance of todolists query
Use some standard SQL and split the query into two different parts to save a lot of unnecessary sorting and field retrieval at the database level. The `CASE WHEN complete THEN 1 ELSE 0 END` syntax should be accepted by any database that implements proper SQL; it was tested in PostgreSQL and sqlite3 without issues. Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to 'releng')
0 files changed, 0 insertions, 0 deletions