Details
-
Type:
Sub-task
-
Status:
Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 2.0
-
Fix Version/s: None
-
Component/s: Database activity module
-
Labels:None
-
Affected Branches:MOODLE_20_STABLE
Description
We don't think the SMALL/MEDIUM/BIG text field distinction is actually necessary for performance in MySQL, and it doesn't apply (or is not the same) on other databases.
Consequently it would be nice to remove it from xmldb in order to:
a) simplify the interface
b) stop people accidentally restricting things to 64KB (but only on certain DBs!) when they don't mean to.
We think all fields could be BIG.
Issue Links
| This issue has a non-specific relationship to: | ||||
| MDL-24490 | User description field size needs to be increased before text to html conversion |
|
|
|
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
-3 as far as looking for some InnoDB tuning options today I arrived to one place showing the (BIG) speed differences between small and big texts under MySQL. Unluckily I haven't the URL right now I just arrived here while mass-triaging performance related issues for next sprint.
Needs confirmation / testing to see / measure those differences... just FYI ciao 
+2