Too many CPT

  • Resolved rvitalia

    (@rvitalia)


    1 year, 9 months ago

    Hi, I’ve a problem with CPT and mySql. I create too many CPT on site, but they’re necessary and I must create other CPT but I’ve a problem with memory of SQL.

    “The issue with this is the default limit imposed by MySQL on the database table rows of roughly 65k bytes per row.

    On your website, the Titles & Meta options with all the CPTs is exceeding 130k bytes of data so this cannot be saved further in the database.

    Because of this, our recommendation is that you assess if you really need that many CPTs since most of what you are doing with them can be achieved with the default pages and using a parent-child relationship between them and reducing the number of CPTs would in turn reduce the size of the option and would help saving the data into the database.

    Since this limit on the row sze is imposed by MySQL it’s not possible to update that data when it exceeds the limit imposed by the server. ”

    How can resolve this problem?
    Thank you so much

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Michael Beckwith

    (@tw2113)

    The BenchPresser

    1 year, 9 months ago

    Honestly not much that can be done from our perspective with the plugin. It is but isn’t not so much what you registered via CPTUI, but more what all is being done with the content types created with our plugin.

    Based on the email you provided above, they’re recommending re-evaluating and restructuring your content architecture somehow to provide a more even balance that also reduces things down below the MySQL limits.

    Another idea, that I must implore is “last ditch only”, would be see if there’s other hosting that has higher MySQL limits, but I can’t say that’s going to be a guarantee.

    Plugin Contributor Michael Beckwith

    (@tw2113)

    The BenchPresser

    1 year, 9 months ago

    Any news or changes here @rvitalia ?

    Thread Starter rvitalia

    (@rvitalia)

    1 year, 8 months ago

    Unfortunately no, our site is really too big and complex (over 20k pages) and it’s difficult to rethink a structure without losing all the SEO acquired over the years

    Plugin Contributor Michael Beckwith

    (@tw2113)

    The BenchPresser

    1 year, 8 months ago

    Noted and understood.

    That said, I’m going to mark this as resolved as there’s not anything that can be done from CPTUI’s side of things.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Too many CPT’ is closed to new replies.