Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-1607

Release editor performs queries too many times

XMLWordPrintable

      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

            warp Kuno Woudt
            acid2 Oliver Charles
            Votes:
            3 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                Bug fixes, 2011-07-18