Informix - Problembeschreibung
Problem IT27540 | Status: Geschlossen |
PERFORMANCE PROBLEM WITH CLIPGETCOUNT ON TIMESERIES COLUMN DEFINED TO USING ROLLING WINDOW CONTAINERS | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Clipgetcount() seems to be much more expensive in execution terms when used on a timeseries using rolling window storage compared to a timeseries stored in a single container. Clipgetcount() seems to have to read every container in the active window list even though it takes arguments defining the range needing to be examined, which appears to be much more expensive then looking at a single container containing a much larger data set for just the 1 timeseries. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC11 and older versions. * **************************************************************** * PROBLEM DESCRIPTION: * * Performance problem with clipgetcount on timeseries column * * defined to use rolling window containers. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.12.2018 04.10.2019 04.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC12 | |
Problem behoben lt. FixList in der Version |