-
Bug
-
Resolution: Fixed
-
Normal
-
NGS - Release Candidate 1
-
None
The following is from my postgres log when I go to /release/add. While these queries are quick, it also runs my bigger queries to find possible missing entities later
2011-03-10 13:24:47 GMT LOG: duration: 0.258 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:47 GMT LOG: duration: 0.135 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:47 GMT LOG: duration: 2.752 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:47 GMT LOG: duration: 1.089 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:47 GMT LOG: duration: 1.991 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:47 GMT LOG: duration: 0.155 ms statement: SELECT id, name FROM release_packaging ORDER BY id
2011-03-10 13:24:47 GMT LOG: duration: 0.227 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:47 GMT LOG: duration: 0.122 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:47 GMT LOG: duration: 3.851 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:47 GMT LOG: duration: 1.028 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:47 GMT LOG: duration: 1.900 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:47 GMT LOG: duration: 0.203 ms statement: SELECT id, name FROM release_packaging ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 0.286 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 0.113 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 2.590 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:48 GMT LOG: duration: 1.057 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:48 GMT LOG: duration: 1.919 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:48 GMT LOG: duration: 0.166 ms statement: SELECT id, name FROM release_packaging ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 0.182 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 0.127 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 3.844 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:48 GMT LOG: duration: 0.993 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:48 GMT LOG: duration: 1.916 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:48 GMT LOG: duration: 0.160 ms statement: SELECT id, name FROM release_packaging ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 0.151 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 0.120 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 3.845 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:48 GMT LOG: duration: 0.759 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:48 GMT LOG: duration: 1.338 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:48 GMT LOG: duration: 0.127 ms statement: SELECT id, name FROM release_packaging ORDER BY id
2011-03-10 13:24:48 GMT LOG: duration: 0.431 ms statement: SELECT id, name, year, parent AS parent_id, child_order, has_discids FROM medium_format
ORDER BY child_order, id
2011-03-10 13:24:48 GMT LOG: duration: 0.381 ms statement: SELECT id, name, year, parent AS parent_id, child_order, has_discids FROM medium_format
ORDER BY child_order, id
2011-03-10 13:24:49 GMT LOG: duration: 0.213 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:49 GMT LOG: duration: 0.100 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:49 GMT LOG: duration: 2.686 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:49 GMT LOG: duration: 1.132 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:49 GMT LOG: duration: 1.966 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:49 GMT LOG: duration: 0.171 ms statement: SELECT id, name FROM release_packaging ORDER BY id
2011-03-10 13:24:50 GMT LOG: duration: 0.257 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:50 GMT LOG: duration: 0.124 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:50 GMT LOG: duration: 3.864 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:50 GMT LOG: duration: 1.047 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:50 GMT LOG: duration: 1.956 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:50 GMT LOG: duration: 0.152 ms statement: SELECT id, name FROM release_packaging ORDER BY id
2011-03-10 13:24:50 GMT LOG: duration: 0.164 ms statement: SELECT id, name FROM release_group_type ORDER BY id
2011-03-10 13:24:50 GMT LOG: duration: 0.121 ms statement: SELECT id, name FROM release_status ORDER BY id
2011-03-10 13:24:50 GMT LOG: duration: 3.826 ms statement: SELECT id, iso_code_3t, iso_code_3b, iso_code_2, name, frequency FROM language ORDER BY name
2011-03-10 13:24:50 GMT LOG: duration: 0.743 ms statement: SELECT id, iso_code, iso_number, name, frequency FROM script ORDER BY name
2011-03-10 13:24:50 GMT LOG: duration: 1.322 ms statement: SELECT id, iso_code, name FROM country ORDER BY name ASC
2011-03-10 13:24:50 GMT LOG: duration: 0.124 ms statement: SELECT id, name FROM release_packaging ORDER BY id
- is related to
-
MBS-2126 Release Editor response times are unacceptable
- Closed