OpenACS / openacs-4 / packages / acs-admin / www / apm

index-oracle.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 08 Aug 17
Commits this week: 0
Total Lines of Code (LoC): 46
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 03 Apr
4:10 pm

gustafn

whitespace changes (remove tabs)

Options
    • -10
    • +10
    ./index-oracle.xql
  2. … 17 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -1
    • +1
    ./index-oracle.xql
  2. … 7834 more files in changeset.
Friday 03 Mar 2017
9:30 am

gustafn

fix issue #3306: missing comma in *-oracle.xql file

Options
    • -1
    • +1
    ./index-oracle.xql
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -4
    • +5
    ./index-oracle.xql
  2. … 2547 more files in changeset.
Wednesday 04 Sep 2013
1:25 pm

gustafn

- add release date to package info

Options
    • -2
    • +3
    ./index-oracle.xql
  2. … 2 more files in changeset.
Thursday 29 Aug 2013
3:39 pm

victorg

Getting rid of last calls to deprecated ad_table. Instead using the list-builder. There is still one call to ad_table within acs-subsite but this page is not linked from anywhere anymore ( probably we remove it later ).

Options
    • -2
    • +2
    ./index-oracle.xql
  2. … 6 more files in changeset.
Monday 10 Mar 2003
1:09 pm

peterm

removing the file count for packages on the APM index page as counting from the file system would be fairly expensive (maybe as much as a second for many packages)

Options
    • -1
    • +0
    ./index-oracle.xql
  2. … 2 more files in changeset.
1:01 pm

peterm

removing the file count for packages on the APM index page as counting from the file system would be fairly expensive (maybe as much as a second for many packages)

Options
    • -1
    • +0
    ./index-oracle.xql
  2. … 2 more files in changeset.
Saturday 01 Dec 2001
4:41 pm

donb

After importing openacs.org users, forums and messages I discovered that it

took literally several minutes to load the APM's home page. This was due

to a rather stupid subselect of the form:

select count(*)

from content_revisions r

where r.revision_id = content_item.get_latest_revision(item_id)

where item_id comes from the package versions table.

It's stupid in both PG and Oracle because get_latest_revision already

joins the latest_revision_id value from cr_items with the content

revisions table thus a simple check for a null return by get_latest_revision

would be sufficient.

It's *really* stupid in Oracle because Oracle won't use the index on

revision_id when checking NULLs so we get two sequential scans of the

cr_revisions table tucked into that one itty-bitty subquery (itself called

once for each package version in ths system).

Which explains why I hadn't noticed it while working on scalability testing

in PG - PG uses the index because its btree index structure handles NULLs.

Meaning this query only fell apart at a rate of O(log2(R)) rather than O(R)

as in Oracle (R being the number of revision objects in the system).

My solution was to rewrite the subselect using "case" rather than "count(*)"

and also to speed up get_latest_revision by having it check for NULL and

return NULL immediately rather than execute the query (in PG this is

accomplished by declaring the function "isstrict", and the executor won't

even call the function if the argument's NULL, making it REALLY fast!).

Options
    • -3
    • +5
    ./index-oracle.xql
  2. … 3 more files in changeset.
Sunday 13 May 2001
3:53 am

donb

Added calls to Dan's new "db_map" routine to make db-specific queries in

the apm index page work.

Options
    • -1
    • +11
    ./index-oracle.xql
  2. … 2 more files in changeset.
Saturday 05 May 2001
7:39 pm

danw

converted apm to store tarballs in the content repository

Options
    • -1
    • +3
    ./index-oracle.xql
  2. … 7 more files in changeset.
Sunday 29 Apr 2001
4:29 am

donb

*** empty log message ***

Options
    • -0
    • +18
    ./index-oracle.xql
  2. … 2 more files in changeset.
Friday 27 Apr 2001
3:41 am

donb

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

Options
    • -0
    • +14
    ./index-oracle.xql
  2. … 60 more files in changeset.