diff options
| author | Dan McGee <dan@archlinux.org> | 2012-10-12 18:34:49 +0200 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2012-10-12 18:35:28 +0200 |
| commit | a71aa2e354599950f4bd464f0f19215f1c581141 (patch) | |
| tree | 2d9ffa08831d69c6fbd5b30e96f0320e6babfbe0 /packages/views | |
| parent | f0b7e73de61c03a5018ed352605e6329611448d2 (diff) | |
| download | archweb-a71aa2e354599950f4bd464f0f19215f1c581141.tar.gz archweb-a71aa2e354599950f4bd464f0f19215f1c581141.tar.xz | |
Make wrong permissions query more efficient
This removes the subplan and per-row query in favor of a LEFT JOIN where
we look for non-matching rows. Tested in sqlite3 and PostgreSQL.
Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to 'packages/views')
0 files changed, 0 insertions, 0 deletions