web stats
Download | Support | Contact
Mirth Corporation
  • Home
  • Products
    • Mirth Connect
    • Mirth Results
    • Mirth Match
    • Mirth Mail
    • Mirth Care
    • Mirth Appliances
    • Mirth Virtual Appliances
    • Mirth Hosted Appliances
  • Services
    • Support
    • Training
    • Consulting
  • Solutions
    • HIEs
    • Hospitals
    • Clinics
    • Laboratories
    • Radiology
    • Vendors
    • Government
  • Community
    • Forums
    • Wiki
    • Issues
    • Source Code
    • Mirth Exchange
    • IRC
    • FAQs
    • Contribute
    • Registration
    • Downloads
  • Company
    • About
    • Mission and Vision
    • Testimonials
    • News
    • Employment Opportunities
    • Contact

Mirth Project

  • Log In Access more options
    • Online Help
    • GreenHopper Help
    • Agile Answers
    • Use Agile By Default
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
    • What’s New
  • Dashboards Access more options (Alt+d)
  • Projects Access more options (Alt+p)
  • Issues Access more options (Alt+i)
  • Agile
  • Mirth Connect
  • MIRTH-199

Normalize message table

  • Log In
  • Views
    • XML
    • Word
    • Printable

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: 3.0
  • Component/s: Server
  • Labels:
    None

Description

Normalize the message table to reduce duplicate data.
  • Options
    • Sort By Name
    • Sort By Date
    • Ascending
    • Descending
    • Download All

Attachments

  1. File
    normalized-message-table.sql
    25/Aug/10 11:09 AM
    1 kB
    Gerald Bortis

Activity

Ascending order - Click to sort in descending order
  • All
  • Comments
  • Work Log
  • History
  • Activity
  • Source
Hide
Permalink
Nordine Vandezande added a comment - 02/Nov/08 1:50 PM
It is probably also a good idea to seperate the CLOB-column in a different table. That would definitely improve dashboard-performance.
Show
Nordine Vandezande added a comment - 02/Nov/08 1:50 PM It is probably also a good idea to seperate the CLOB-column in a different table. That would definitely improve dashboard-performance.
Hide
Permalink
Gerald Bortis added a comment - 25/Aug/10 11:09 AM
First attempt at normalizing the MESSAGE table.
Show
Gerald Bortis added a comment - 25/Aug/10 11:09 AM First attempt at normalizing the MESSAGE table.

People

  • Assignee:
    Gerald Bortis
    Reporter:
    Gerald Bortis
Vote (4)
Watch (1)

Dates

  • Created:
    18/Dec/06 12:25 PM
    Updated:
    25/Aug/10 11:09 AM
  • Atlassian JIRA (v5.0.3#729-sha1:bf569e4)
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Mirth Corporation. Try JIRA - bug tracking software for your team.