Februar 8
Minhchau Dang aktualisiert LPS-63027.
Minhchau Dang aktualisiert LPS-57243.
Februar 4
Minhchau Dang kommentierte LPS-62914.
18:09 We really shouldn't be updating the Group_ table one entry at a time. Instead, we should come up with some way of doing the updates in bulk. One approach would be to build the tree path for all root sites, then update everything on the next level by looking at the immediate children of those nodes that we've set a tree path on by using temporary tables. That way, rather than updating each group one at a time, we will perform a number of updates equal to the deepest part of the tree. All we would need is to find out how to concatenate strings across databases. The pseudo-code for that would look something like this: {code} update Group_ set treePath = concat('/', groupId) where parentGroupId = 0 count_value = select count(*) from Group_ where treePath is null while count_value > 0: create temporary table GroupsToUpdate ( select ChildGroup.groupId as groupId, concat(ParentGroup.treePath, '/', ChildGroup.groupId) as treePath from Group_ ChildGroup inner join Group_ ParentGroup on ChildGroup.parentGroupId = ParentGroup.groupId where ChildGroup.treePath is null and ParentGroup.treePath is not null ) add index to groupId column for GroupsToUpdate update Group_ set treePath = ( select treePath from GroupsToUpdate where Group_.groupId = GroupsToUpdate.groupId ) where exists ( select 1 from GroupsToUpdate where Group_.groupId = GroupsToUpdate.groupId ) drop table GroupsToUpdate count_value = select count(*) from Group_ where treePath is null {code}
Januar 27
Minhchau Dang aktualisiert LPS-62552.
Januar 25
Minhchau Dang aktualisiert LPS-49899.
Minhchau Dang aktualisiert LPS-48386.
Minhchau Dang aktualisiert LPS-49899.
Januar 22
Minhchau Dang aktualisiert LPS-60388.
Minhchau Dang aktualisiert LPS-60369.
Dezember 28
Minhchau Dang aktualisiert LPS-60383.
Die Aktivitäten von Minhchau Dang abonnieren. (Öffnet neues Fenster)