-
Type:
Incident report
-
Resolution: Fixed
-
Priority:
Major
-
None
-
Affects Version/s: 1.8, 1.9.0 (alpha)
-
Component/s: Frontend (F)
-
None
overview -> data, maybe other places. same value mapping is retrieved from the database multiple times, for example :
Time:0.016482 LONG SQL: SELECT newvalue FROM mappings WHERE valuemapid=8 AND value='1'
Time:0.000397 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'
Time:0.000308 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'
Time:0.000427 SQL: SELECT newvalue FROM mappings WHERE valuemapid=8 AND value='1'
Time:0.000318 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='0'
Time:0.000283 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'
Time:0.000409 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'
here 7 queries are executed, when 3 would have been enough (8-1, 1-1, 1-0)