Project

General

Profile

Bug #8099

Plans table reaching row size limits

Added by krileon 2 months ago.

Status:
Feedback
Priority:
High
Assignee:
-
Target version:
Start date:
23 July 2020
Due date:
% Done:

0%

Estimated time:

Description

The _cbsubs_plans table contains 162 columns. Many are varchar(255) with some varchar(256) (is this a bug?) columns that could be converted to text type. Changing them to text type would result in a smaller 20 byte pointer to reduce row size and prevent hitting row size limit errors (8k byte default for innodb). Several yes/no (1/0) columns are also using tinyint(4) instead of just tinyint(1) wasting additional bytes.

https://www.joomlapolis.com/forum/255-developer-members-support/242725-1118-error-on-cbsubs?start=6

Also available in: Atom PDF