Informix - Problembeschreibung
Problem IT09622 | Status: Geschlossen |
SELECT ON SYSMASTER DATABASE IS MORE THAN 100 TIMES SLOWER AFTER UPGRADE TO 12.10 | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Select on sysmaster database is more than 100 times slower after upgrade to 12.10. Customer has a lot of databases and tables (total about 500-700 thousand partitions). After upgrade from 11.50 to 12.10 all is going slower. Found following: select count(*) from sysmaster:systabnames; 11.50.FC9 Tables 200 2000 20000 200000 runtime 2.880s 2.279s 3.222s 6.517s 12.10.FC4W1 Tables 200 2000 20000 200000 runtime 4.633s 10.334s 227.489s 1057.387s | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * user of informix database server * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to 12.10.xC5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.06.2015 30.12.2015 30.12.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC5 | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |