Uploaded image for project: 'ASTPP Community'
  1. ASTPP Community
  2. ASTPPCOM-462

Discuss: Change CHAR to VARCHAR in routes & outbound_routes tables

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      These tables get big quickly (71K rows per rate card for me), and account for 92% of my DB even after several months of live calls. In my testing, changing the CHAR columns to VARCHAR saves 41% of the space of both tables, that's currently 36% of my DB space saved. This seems inefficient, particularly if RAM is allocated to storing all those empty chars.

      Are there any advantages to using CHAR that aren't outweighed by the saving in DB size, and thus RAM demand?

      Also routes.pattern has length 40, which is twice the length of longest number expected, and seems excessive when compared to outbound_routes.pattern which has length 15? If we switch to VARCHAR, we could probably ignore this though as the extra data won't get stored.

        Attachments

          Activity

            People

            Assignee:
            samir.doshi Samir Doshi
            Reporter:
            alexheylin alexheylin
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: