bug-procs-postgresql.xql

  • last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Switched views for filtered queries that return a bug assigned to a

particular user. The workflow views invoked in these queries simply

do not scale well. This needs to be addressed fundamentally in workwflow

at some point but hacking bug-tracker seems easiest for now.

  1. … 2 more files in changeset.
Finally figured out the obnoxious main query and rewrote the pagination

query to match my new understanding ...

  1. … 1 more file in changeset.
Added per-instance list builder caching ...

  1. … 4 more files in changeset.
Ahem. Pagination might work now ... it didn't really before.

  1. … 2 more files in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
Removed one join with acs_users_all that was unnecessary. Removed on call of acs_users_all and replaced with persons. Works now for openacs.org

search and syndication for bugs

  1. … 3 more files in changeset.
There was an extra acs_users_all assignee join in the first part of

the query which caused the set of returned rows to be the cartesian

product of the bugs X keywords X users on system = very very slow

for anything more than a trivial number of users.

It still returns bugs x keywords rows which is not great but seems tolerable.

  1. … 1 more file in changeset.
merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

  1. … 834 more files in changeset.
Merged changes on oacs-5-0 branch from jcd-504-merge to lars-504-2-merge (changes made since 5.0.4 release) onto oacs-5-1 branch

  1. … 5 more files in changeset.
Lower instead of upper

  1. … 2 more files in changeset.
Fixed bug with sorting bugs list

  1. … 2 more files in changeset.
Adding a column to the bug list showing who is assigned to which bug.

  1. … 2 more files in changeset.
in the bug listing query, setting parent_enabled_action_id to null in where clause to only get top workflows

  1. … 1 more file in changeset.
Unassigned query not ported to PG

  1. … 3 more files in changeset.
Using list builder for bug listing

  1. … 24 more files in changeset.
Merged over latest version from HEAD

  1. … 114 more files in changeset.
Latest version of bug-tracker/ticket-tracker, using workflow

  1. … 114 more files in changeset.
Cleaned up bug.tcl page, now using new form builder enhancements

    • -0
    • +104
    ./bug-procs-postgresql.xql
  1. … 10 more files in changeset.