[fossology/fossology] 4df335: perf(ui): Reduce load time for tree view


Shaheem Azmal M MD <noreply@...>
 

Branch: refs/heads/master
Home: https://github.com/fossology/fossology
Commit: 4df3358c2124be2839f9610324c8682d31823393
https://github.com/fossology/fossology/commit/4df3358c2124be2839f9610324c8682d31823393
Author: Gaurav Mishra <@gmishx>
Date: 2020-09-21 (Mon, 21 Sep 2020)

Changed paths:
M src/lib/php/Dao/ClearingDao.php
M src/lib/php/Data/ClearingDecision.php
M src/lib/php/Proxy/UploadTreeProxy.php
M src/lib/php/Proxy/test/UploadTreeProxyTest.php
M src/www/ui/api/Helper/UploadHelper.php
M src/www/ui/async/AjaxExplorer.php
M src/www/ui/core-schema.dat
M src/www/ui/ui-clearing-view.php

Log Message:
-----------
perf(ui): Reduce load time for tree view

1. Update CTE provided by ClearingDao::getRelevantDecisionsCte() to sort
and unique only if required and reduce CTE count from 2 to 1 (will
benefit PG < 12).
2. Remove getClearingDecisionsCount() and getClearingDecisionsCount() as
they are no longer helpful.
3. Update UploadTreeProxy::getQueryCondition() to use simple SORT and
DISTINCT instead of WindowAgg.
4. In AjaxExplorer, new function updateFilesToBeCleared() to cache
itemtree bounds which are already calculated to reduce DB reads.
5. Updated index "clearing_decision_event_clearing_fk_idx" to include
"clearing_event_fk" making join on cde as INDEX ONLY SCAN.
6. New index "clearing_event_pk_removed_idx" to optimize ajax view
query.

Signed-off-by: Gaurav Mishra <@gmishx>


Commit: b7a846ca391b091407b8173ec0f74a1dbab5bc46
https://github.com/fossology/fossology/commit/b7a846ca391b091407b8173ec0f74a1dbab5bc46
Author: Shaheem Azmal M MD <shaheem.azmal@...>
Date: 2020-09-28 (Mon, 28 Sep 2020)

Changed paths:
M src/lib/php/Dao/ClearingDao.php
M src/lib/php/Data/ClearingDecision.php
M src/lib/php/Proxy/UploadTreeProxy.php
M src/lib/php/Proxy/test/UploadTreeProxyTest.php
M src/www/ui/api/Helper/UploadHelper.php
M src/www/ui/async/AjaxExplorer.php
M src/www/ui/core-schema.dat
M src/www/ui/ui-clearing-view.php

Log Message:
-----------
Merge pull request #1576 from siemens/fix/ui/clearing-count

perf(ui): Reduce load time for license browser

Review-by: shaheem.azmal@...
Tested-by: shaheem.azmal@...


Compare: https://github.com/fossology/fossology/compare/9e71f44caf60...b7a846ca391b

Join fossology-commits@lists.fossology.org to automatically receive all group messages.