Meta Box

Any disadvantage creating all table feilds as TEXT?

Support › MB Custom Table › Any disadvantage creating all table feilds as TEXT?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • February 19, 2023 at 8:03 PM #40606
    Akhil K AAkhil K A
    Participant

    Hi

    I'm new to Meta Box. For many years, I've been using ACF Pro for Custom fields.

    I saw a setting while creating CF: "Save data in a custom table.

    Since I'm not a database Pro, I'm unable to create column types manually by coding.

    But I really like to have separate tables for each CF group for just organizing everything!

    Is there any significant disadvantage using all column types as TEXT (If I check "Create table automatically")?

    Note: My site got 7 Custom Post Types, More than 100 taxonomies, and CF (10 CF Groups).

    Thanks
    Akhil

    February 20, 2023 at 9:03 PM #40619
    PeterPeter
    Moderator

    Hello there,

    You can read more about the differences between data types here https://www.w3schools.com/sql/sql_datatypes.aspf

    February 20, 2023 at 9:18 PM #40621
    Akhil K AAkhil K A
    Participant

    That was my question.

    My question was regarding performance.

    Anyways, I switched the plugin.

    Thanks!

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.