• last updated 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixed item type displaying

upgrade script to remove the unused 3-col with header layout.

major refactoring of the configure proc for correct layout changing. some refactoring of configure_dispatch. several new helper procs

    • -136
    • +267
    ./packages/new-portal/tcl/portal-procs.tcl
    • -35
    • +40
    ./packages/new-portal/tcl/portal-procs.xql
don't cache hidden element list

    • -2
    • +2
    ./packages/new-portal/www/place-element.tcl
fix brokeness

    • -20
    • +54
    ./packages/new-portal/www/layouts/simple3.adp
    • -3
    • +26
    ./packages/new-portal/www/layouts/simple3.tcl
moved the move_to_page update query to new move_to_page proc

removing unused 3 col with header layout

    • -13
    • +1
    ./packages/new-portal/sql/oracle/defaults.sql
added nowrap CSS for the main text of the header

The original .xql contained sysdate.

    • -0
    • +18
    ./packages/payflowpro/tcl/payflowpro-procs-oracle.xql
    • -0
    • +18
    ./packages/payflowpro/tcl/payflowpro-procs-postgresql.xql
    • -14
    • +0
    ./packages/payflowpro/tcl/payflowpro-procs.xql

Removed " at the end of the query.

Replaced cleaned_package_key with package_key.

small fix

    • -1
    • +1
    ./packages/dotlrn/tcl/community-procs.xql
fix typo

andrew's tuning mods

    • -2
    • +17
    ./packages/dotlrn/tcl/community-procs.tcl
    • -1
    • +1
    ./packages/dotlrn/tcl/community-procs.xql
    • -2
    • +2
    ./packages/dotlrn/www/admin/users-oracle.xql
adding some indexes

added some indexes

commit

Performance enchancements based on our testing

added "(select acs.magic_object_id('registered_users') from dual)"

clause to registered_users view based on results from scalability testing.

Removed irrelevant calls to apm_tcl_or_sql_name_from_package_key.

    • -1
    • +0
    ./packages/payflowpro/www/admin/index.tcl
added site_nodes_parent_id_idx based on results from scalability testing

changed select_non_member_clubs to use minus anti-join

removed unused admin_p checks

select_non_dotlrn_users_count query now using andrew's faster minus antijoin

    • -31
    • +31
    ./packages/dotlrn/www/admin/users-oracle.xql
added global posting history

    • -0
    • +104
    ./packages/dotlrn-forums/www/user-history.adp
    • -0
    • +70
    ./packages/dotlrn-forums/www/user-history.tcl
    • -0
    • +20
    ./packages/dotlrn-forums/www/user-history.xql

Fixed dublicate Info.InputType.

added do abort

fixed name of portlet and newness tagging

added newness tagging

    • -2
    • +4
    ./packages/forums/www/forum-view-oracle.xql
    • -1
    • +2
    ./packages/forums/www/index-oracle.xql
improved query a tad