Meta Box

Slow archive queries

Support › MB Custom Table › Slow archive queriesResolved

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • February 7, 2022 at 3:51 AM #33692
    shmaltzshmaltz
    Participant

    I noticed that my archive pages have very slow queries being run because of the custom tables.

    For each custom field (over 20) this guery loads (even though I am not even displaying any of the fields on the archive):

    ALTER TABLE listing_address CHANGE COLUMN geometry geometry TEXT
    MetaBox\C\API::create()
    Plugin: meta-box-aio 1 0.0764

    February 8, 2022 at 9:17 PM #33763
    Long NguyenLong Nguyen
    Moderator

    Hi,

    Thanks for your feedback.

    The API create() of the custom table has to run on page load to check if the table exists or not. If you do not want to run the query anytime, you can create a table with coding and run it one time, then comment out or delete the code that creates the table.

    Refer to this documentation https://docs.metabox.io/extensions/mb-custom-table/#creating-custom-tables

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