Uploaded image for project: 'FTS'
  1. FTS
  2. FTS-599

Optimize database schema

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • fts 3.6.0
    • None
    • MySQL
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • None

    Description

      Depending on the results from FTS-596, optimize the database schema.
      Just some ideas that have been discussed briefly:

      1) Change file state and job state to an enum
      2) Use a hash index instead of a btree for those
      3) Change type of some columns (specially varchars, longtexts)

      Attachments

        Issue Links

          Activity

            People

              aalvarez Alejandro Alvarez Ayllon (Inactive)
              aalvarez Alejandro Alvarez Ayllon (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                Actual Start: