Re: [jcms] Opinion request on: change params field from MEDIUMTEXT to LONGTEXT

53 views
Skip to first unread message

Michael Babker

unread,
Oct 23, 2018, 6:59:21 PM10/23/18
to joomla-...@googlegroups.com
As often as this comes up, sarcastically I think we just need to make every column the biggest allowed for each data type and stop fielding these requests.

On a serious note, if you are really storing this much JSON data into a single column, odds are you are at a point where you need to consider a different data storage model (possibly an EAV model loosely similar to the user profiles table).  There's a rather noticeable performance penalty for having to decode this large of a JSON string into an object or array, and even moreso if you're pushing this into a Joomla\Registry\Registry object.

On Tue, Oct 23, 2018 at 5:24 PM Edric Navarro (enav) <digitalco...@gmail.com> wrote:
Hi

As you guys already know lots of tables use the column "params" to store JSON formatted data, this column is MEDIUMTEXT and i do like to see if it is possible to change it to LONGTEXT to support more data.

What are the pros and cons of this idea. This request seems easy to do and may not need mayor source code modification unless i'm wrong

I use this field daily and few times i have reach the max capacity of this field which causes and ugly error. 

MEDIUMTEXT meet 80% of my normal requirements but LONGTEXT will cover 100%


Regards




 

--
You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to joomla-dev-cm...@googlegroups.com.
To post to this group, send email to joomla-...@googlegroups.com.
Visit this group at https://groups.google.com/group/joomla-dev-cms.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages