summaryrefslogtreecommitdiffstats
path: root/public
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2012-11-20 22:57:05 +0100
committerDan McGee <dan@archlinux.org>2012-11-21 01:17:48 +0100
commit160a08bba5324b25abd9e866b884c91d75e597b0 (patch)
treef1e6dd7cd724a584682970fa43cfdcba0b54ca40 /public
parent9e9157d0a8cbf9ea076231e438fb30f58bff8e29 (diff)
downloadarchweb-160a08bba5324b25abd9e866b884c91d75e597b0.tar.gz
archweb-160a08bba5324b25abd9e866b884c91d75e597b0.tar.xz
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 'public')
0 files changed, 0 insertions, 0 deletions