Slow archive queries - Meta Box

This topic has 1 reply, 2 voices, and was last updated 2 years, 10 months ago by Long Nguyen.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
February 7, 2022 at 3:51 AM #33692

shmaltz
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

Add New Note to this Reply

February 8, 2022 at 9:17 PM #33763

Long 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

Add New Note to this Reply
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.