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

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 47
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 77,885
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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -40
    • +31
    ./postgresql/content-create.sql
    • -46
    • +26
    ./postgresql/content-folder.sql
    • -41
    • +19
    ./postgresql/content-item.sql
    • -41
    • +23
    ./postgresql/content-keyword.sql
    • -28
    • +16
    ./postgresql/content-perms.sql
    • -19
    • +9
    ./postgresql/content-revision.sql
    • -41
    • +19
    ./postgresql/content-type.sql
    • -6
    • +5
    ./postgresql/types-create.sql
  9. … 55 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
    ./oracle/content-item.sql
    • -2
    • +2
    ./postgresql/content-item.sql
  3. … 2 more files in changeset.
Friday 16 Nov 2001
4:11 am

donb

1. The PG port of apm__register_parameter had a tiny error which caused it

to not set the new parameter to its default value in any of the effected

package instances.

2. Glossary - added admin as a parent of glossary_admin so admins can admin.

3. edit-this-page PG: removed code that was written because of #1 above

4. edit-this-page Oracle: finished the datamodel port, added drop script

Options
    • -4
    • +3
    ./oracle/content-create.sql
  2. … 8 more files in changeset.
Thursday 15 Nov 2001
2:47 am

donb

1. Fixed permissions bug in the PG version (missing OR clause in a view)

2. Added (untested thus far) site-wide-search to glossary

3. Added centralized support for importing files into the CR (either into

the filesystem or the database).

4. Fixed wp-slim. Fixed it some more. Fixed it again. It still needs

more fixing.

Options
    • -1
    • +3
    ./oracle/content-create.sql
    • -8
    • +92
    ./oracle/content-image.sql
    • -4
    • +5
    ./oracle/content-revision.sql
    • -1
    • +2
    ./oracle/packages-create.sql
    • -1
    • +3
    ./postgresql/content-create.sql
    • -1
    • +6
    ./postgresql/content-image-drop.sql
    • -1
    • +128
    ./postgresql/content-image.sql
    • -7
    • +7
    ./postgresql/content-item.sql
  9. … 54 more files in changeset.
Wednesday 07 Nov 2001
11:55 pm

donb

1. Typo in the alter table in the PG version ...

2. Just folded the alter tables into the cr_folders table definition. This

is still pre-beta ...

Options
    • -8
    • +5
    ./oracle/content-create.sql
    • -4
    • +5
    ./postgresql/content-create.sql
5:13 am

jong

added package_id to cr_folders

Options
    • -1
    • +7
    ./oracle/content-create.sql
5:12 am

jong

added a constraint

Options
    • -2
    • +5
    ./postgresql/content-create.sql
4:54 am

jong

added package_id to cr_folders

Options
    • -1
    • +6
    ./postgresql/content-create.sql
Tuesday 30 Oct 2001
6:45 am

danw

fixed mutating tables problem with cr_cleanup_cr_files_del_trg trigger

Options
    • -2
    • +2
    ./oracle/content-create.sql
6:15 am

danw

fixed mutating tables problem with cr_cleanup_cr_files_del_trg trigger

Options
    • -5
    • +4
    ./oracle/content-create.sql
Tuesday 23 Oct 2001
9:41 pm

donb

Dave Bauer's patches ...

Options
    • -2
    • +83
    ./postgresql/content-folder.sql
    • -167
    • +5
    ./postgresql/content-item.sql
Friday 19 Oct 2001
4:11 am

donb

*** empty log message ***

Options
    • -2
    • +6
    ./oracle/content-search.sql
  2. … 7 more files in changeset.
Tuesday 16 Oct 2001
3:36 am

donb

A variety of minor fixes ...

Options
    • -23
    • +22
    ./oracle/content-create.sql
  2. … 3 more files in changeset.
Sunday 14 Oct 2001
11:02 pm

donb

Fixed Dan's new trigger ...

Options
    • -2
    • +2
    ./oracle/content-create.sql
Tuesday 09 Oct 2001
6:31 am

danw

more image handling fixes submitted by Walter McGinnis

Options
    • -1
    • +10
    ./oracle/content-create.sql
    • -2
    • +2
    ./oracle/content-image-drop.sql
    • -9
    • +7
    ./oracle/content-image.sql
1:33 am

danw

fixed delete file trigger

Options
    • -8
    • +9
    ./oracle/content-create.sql
Wednesday 03 Oct 2001
6:41 am

danw

fixed infinite recursion problem with cr_keywords update trigger

Options
    • -2
    • +4
    ./postgresql/content-create.sql
Friday 28 Sep 2001
12:48 am

danw

added support for multiple file storage areas

Options
    • -29
    • +62
    ./oracle/content-create.sql
    • -1
    • +2
    ./oracle/content-drop.sql
    • -0
    • +189
    ./oracle/content-image.sql
    • -30
    • +74
    ./postgresql/content-create.sql
    • -1
    • +2
    ./postgresql/content-drop.sql
    • -1
    • +6
    ./postgresql/content-image-drop.sql
    • -0
    • +132
    ./postgresql/content-image.sql
    • -1
    • +162
    ./postgresql/content-item.sql
  9. … 4 more files in changeset.
Tuesday 25 Sep 2001
1:45 am

danw

added name method support for content_revision type

Options
    • -1
    • +11
    ./postgresql/content-revision.sql
    • -2
    • +2
    ./postgresql/types-create.sql
  3. … 4 more files in changeset.
Monday 17 Sep 2001
7:16 am

danw

moved CMS stuff to CR so that content can be displayed by the search interface without requiring the user to load cms

Options
    • -2
    • +2
    ./postgresql/content-create.sql
  2. … 21 more files in changeset.
Friday 14 Sep 2001
6:53 am

danw

updated search support to include templates and images

Options
    • -11
    • +9
    ./postgresql/content-create.sql
    • -0
    • +46
    ./postgresql/content-search.sql
  3. … 5 more files in changeset.
Monday 10 Sep 2001
2:43 pm

danw

added virtual url support for CR

Options
    • -0
    • +0
    ./postgresql/content-create.sql
  2. … 5 more files in changeset.
Sunday 09 Sep 2001
8:09 pm

danw

removed DataProvider Contract Temporarily

Options
    • -2
    • +79
    ./postgresql/content-create.sql
  2. … 1 more file in changeset.
1:38 am

danw

added dependency for acs-service-contract

Options
    • -5
    • +4
    ./postgresql/content-create.sql
  2. … 1 more file in changeset.
Saturday 08 Sep 2001
5:20 pm

danw

modified CR to provide the FtsContentProvider interface

Options
    • -3
    • +2
    ./postgresql/content-create.sql
    • -4
    • +4
    ./postgresql/content-search.sql
  3. … 2 more files in changeset.
1:48 am

danw

added service content support to convert CR into a content provider for search

Options
    • -1
    • +15
    ./postgresql/content-drop.sql
    • -93
    • +52
    ./postgresql/content-search.sql
Wednesday 05 Sep 2001
2:09 am

danw

fixed definition of item relationships

Options
    • -2
    • +2
    ./postgresql/content-item.sql
Tuesday 04 Sep 2001
6:50 am

danw

fixed closing of cursors after an exception

Options
    • -1
    • +7
    ./oracle/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
    ./oracle/content-item.sql
Friday 31 Aug 2001
4:28 am

danw

fixed template functions

Options
    • -6
    • +12
    ./postgresql/content-revision.sql
  2. … 2 more files in changeset.