Project

General

Profile

Feature #145

Change the learning object structure

Added by Sven Vanpoucke almost 10 years ago. Updated over 7 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
04/11/2009
Due date:
% Done:

0%

Estimated time:
Complexity:
Normal

Description

The learning-objects table is not optimized at all. Types are literal (should be int), title, description and comment should not be in the same table, as they represent variable length data type. They should, instead, be in a separate table in a 1-1 relationship (learning-objects-details table for example). The problem is that the learning-object could very quickly grow above 1000000 elements, at which points MySQL is known to loose performance considerably on variable-length rows.

History

#1

Updated by Sven Vanpoucke over 9 years ago

  • Target version changed from 2 to 7
#2

Updated by Stefaan Vanbillemont over 8 years ago

  • Project changed from Chamilo LCMS Connect to Repository
  • Category deleted (4)
#3

Updated by Stefaan Vanbillemont over 8 years ago

  • Target version changed from 7 to 2.1.0
#4

Updated by Stefaan Vanbillemont over 8 years ago

  • Target version changed from 2.1.0 to 55
#5

Updated by Stefaan Vanbillemont over 8 years ago

  • Target version changed from 55 to Backlog (default)

Also available in: Atom PDF