MySource Matrix Developer

MySource Matrix Developer Newsletter Issue 141
Friday 24th August 2007

covers versions 3.12.7 stable, 3.14.3 stable, 3.16.0 RC1, 3.17.0 development

News

No News Is Good News

There is no general MySource Matrix developer news this week.

New Features

Lookup Value System Performance

Added to: 3.17.0 development

The performance of the lookup values system - used for determining the appropriate design and/or paint layout for a page - has been improved considerably. Preliminary testing has seen the number of queries required for getting design or paint layout information reduced by an average of 50pc.

Planned Development

No new generic features are currently scheduled for development.

Upgrading

3.17.0 Development

Additional queries:

These queries are required to move existing development systems to the new lookup value system.

Before running, and before updating your code, please ensure that rollback has been disabled. Please see the Rollback Management Guide for information on how to do this.

Once rollback is disabled, update your code base, then run these queries:

PostgreSQL Systems Only

DELETE FROM sq_ast_lookup_value
WHERE       inhd = 1;

ALTER TABLE sq_ast_lookup_value
DROP COLUMN inhd;

ALTER table sq_ast_lookup_value ADD COLUMN depth integer;

CREATE INDEX sq_ast_lookup_value_depth ON sq_ast_lookup_value (depth);

UPDATE sq_ast_lookup_value
SET    url = url
           ||'/'
WHERE  url IN (SELECT url
             FROM   sq_ast_lookup_value lv
             WHERE  lv.url IN (SELECT url
                               FROM   sq_ast_lookup l
                               WHERE  l.assetid IN (SELECT majorid
                                                    FROM   sq_ast_lnk
                                                    WHERE  value LIKE 'override::%')));

UPDATE sq_ast_lookup_value
           SET depth = l.depth
           FROM (SELECT url, (length(url) - length(replace(url, '/', ''))) as depth FROM sq_ast_lookup_value) AS l
           WHERE sq_ast_lookup_value.url = l.url;

ALTER table sq_ast_lookup_value ALTER COLUMN depth SET NOT NULL;

ALTER TABLE sq_rb_ast_lookup_value
DROP COLUMN inhd;

ALTER table sq_rb_ast_lookup_value ADD COLUMN depth integer;

CREATE INDEX sq_rb_ast_lookup_value_depth ON sq_rb_ast_lookup_value (depth);

Oracle Systems Only

DELETE FROM sq_ast_lookup_value
WHERE       inhd = 1;

ALTER TABLE sq_ast_lookup_value
DROP COLUMN inhd;

ALTER table sq_ast_lookup_value ADD depth integer;

CREATE INDEX sq_ast_lookup_value_depth ON sq_ast_lookup_value (depth);

UPDATE sq_ast_lookup_value
SET    url = url
            ||'/'
WHERE  url IN (SELECT url
              FROM   sq_ast_lookup_value lv
              WHERE  lv.url IN (SELECT url
                                FROM   sq_ast_lookup l
                                WHERE  L.assetid IN (SELECT majorid
                                                     FROM   sq_ast_lnk
                                                     WHERE  value LIKE 'override::%')));

UPDATE sq_ast_lookup_value lv
SET    lv.depth = (SELECT (LENGTH(url) - LENGTH(REPLACE(url,'/',''))) AS depth
                  FROM   sq_ast_lookup_value L
                  WHERE  lv.url = l.url
                         AND ROWNUM = 1);

ALTER table sq_ast_lookup_value MODIFY depth NOT NULL;

ALTER TABLE sq_rb_ast_lookup_value
DROP COLUMN inhd;

ALTER table sq_rb_ast_lookup_value ADD depth integer;

CREATE INDEX sq_rb_ast_lookup_value_depth ON sq_rb_ast_lookup_value (depth);

After running, remember to turn rollback back on, if you had to disable it previously. Again, please consult the Rollback Management Guide for the procedure.

Additional comments: No additional upgrade steps are required.

New Bugs Added To Bug Tracker

Notes:

Bug #2564 ("CSS File asset's cached File asset getting the wrong URL", reported by Christophe Olivar on August 3rd) was marked as Can Not Replicate after both the original reporter and another developer was unable to reproduce on PostgreSQL and Oracle systems.

New Feature Requests Added To Bug Tracker

Bugs Fixed In The Bug Tracker

View Comments