Openfire (ARCHIVED)

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.6.1
• Fix Version/s: 2.6.2
• Component/s: Database
• Labels:

  None

The pubsubNode table is holding some n relationships by encoding strings in big fields. This is generating some problems in old versions of MySQL or hitting some limits of SqlServer. We can move the n relationships (e.g. contacts, roster groups, reply rooms, etc.) to a new table thus reducing the size of pubsubNode. Also make sure that primary keys and indexes are not reaching any db limit.

• Assignee:

  Matt Tucker

  Reporter:

  Gaston Dombiak

• Created:

  04/13/06 12:59 AM

  Updated:

  04/13/06 01:55 AM

  Resolved:

  04/13/06 01:55 AM