Truncate WEBUI_ViewSelection tables on startup #447
Comments
teosarca
added a commit
that referenced
this issue
Jun 9, 2017
metas-ts
added a commit
to metasfresh/metasfresh
that referenced
this issue
Jun 14, 2017
[#878](metasfresh/metasfresh-webui-frontend-legacy#878) Error firework when logout [#880](metasfresh/metasfresh-webui-frontend-legacy#880) Change Icon for URL Link [#881](metasfresh/metasfresh-webui-frontend-legacy#881) Error when pressing Action Menu in Collapsible Grid Window [#883](metasfresh/metasfresh-webui-frontend-legacy#883) hu editor doesn't update [#451](metasfresh/metasfresh-webui-api-legacy#451) Provide view sticky filters to be displayed by frontend [#456](metasfresh/metasfresh-webui-api-legacy#456) Outbound Mail endpoint prototype [#1807](#1807) Fix "Create primary key" process [#879](metasfresh/metasfresh-webui-frontend-legacy#879) Avatar Picture not deleted from Header when cleared in Profile Settings [#1802](#1802) picking terminal is not opening [#436](metasfresh/metasfresh-webui-api-legacy#436) Manufacturing Order Issue not possible after barcode filtering [#453](metasfresh/metasfresh-webui-api-legacy#453) Password process parameters shall allow showing the password [#849](metasfresh/metasfresh-webui-frontend-legacy#849) manufacturing order doesn't open [#437](metasfresh/metasfresh-webui-api-legacy#437) Load/ Reload of delivery Days window takes too long. [#446](metasfresh/metasfresh-webui-api-legacy#446) Cannot open the menu when logged in as System Administrator [#433](metasfresh/metasfresh-webui-api-legacy#433) Show Manufacturing Order number in window header [#1793](#1793) fix jasper document for vendor returns [#848](metasfresh/metasfresh-webui-frontend-legacy#848) notifications don't update [#400](metasfresh/metasfresh-webui-api-legacy#400) minimum password length error message not displayed [#444](metasfresh/metasfresh-webui-api-legacy#444) Make Dashboard Translatable [#447](metasfresh/metasfresh-webui-api-legacy#447) Truncate WEBUI_ViewSelection tables on startup [#847](metasfresh/metasfresh-webui-frontend-legacy#847) Loading of empty delivery Days Window take long [#1735](#1735) istransferwhennull not working in webUI but in java client [#1748](#1748) Project Documentation: Screenshots [#795](metasfresh/metasfresh-webui-frontend-legacy#795) On tab stale event, don't refresh tabs which are queryOnLoad but are not the active tab me-45
|
Tested after the last rollout on w101. Done/ Closing. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Is this a bug or feature request?
What is the current behavior?
WEBUI_ViewSelection and WEBUI_ViewSelectionLine tables tend to grow quickly.
This could affect the overall performance when browsing views.
e.g. on w101, "select count(1) from T_WEBUI_ViewSelection" returns "11 315 919" rows!
What is the expected or desired behavior?
On webui server start, cleanup those temporary tables.
This might be contradictory to #35 but at the moment we are not persisting the view state anyways (like filters, sticky filters, order bys etc).
When we will do that, then we might come up with a different cleanup strategy.
The text was updated successfully, but these errors were encountered: