OpenACS / openacs-4 / packages / acs-content-repository / sql / oracle

content-item.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 22 May
Commits this week: 0
Total Lines of Code (LoC): 1,768
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 12 May 2002
10:57 pm

donb

Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

Options
    • -2
    • +2
    ./content-item.sql
  2. … 58 more files in changeset.
Thursday 04 Apr 2002
5:00 am

yon

added function for updating last_modified time of a content_item with cascading

Options
    • -3
    • +22
    ./content-item.sql
  2. … 3 more files in changeset.
Sunday 31 Mar 2002
11:08 pm

donb

Applied Michael Steigman's patches 199-201, which fixes package spec/body

mismatches allowed by Oracle 8i but not by 9i.

Options
    • -2
    • +2
    ./content-item.sql
  2. … 4 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
    • -1
    • +5
    ./content-item.sql
  2. … 3 more files in changeset.
Tuesday 04 Sep 2001
6:50 am

danw

fixed closing of cursors after an exception

Options
    • -1
    • +7
    ./content-item.sql
  2. … 4 more files in changeset.
Sunday 02 Sep 2001
5:15 pm

danw

fixed RI problem with oracle due to text not being an allowed storage_type

Options
    • -2
    • +9
    ./content-item.sql
Wednesday 29 Aug 2001
1:31 am

danw

more cleanup of cms - content upload and display

Options
    • -1
    • +2
    ./content-item.sql
  2. … 9 more files in changeset.
Saturday 25 Aug 2001
4:22 pm

danw

removed circular dependency due to workflow

Options
    • -26
    • +38
    ./content-item.sql
  2. … 4 more files in changeset.
Friday 11 May 2001
6:43 am

danw

added support for storing content repository items in the file system

Options
    • -7
    • +10
    ./content-item.sql
  2. … 8 more files in changeset.
Saturday 24 Mar 2001
11:00 pm

danw

restructuring directory structure for openacs porting

Options
    • -0
    • +1682
    ./content-item.sql
  2. … 53 more files in changeset.