這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

Add Index To Autoload

外掛說明

Important: since WordPress 5.3, WordPress already has an index on the autoload field: https://core.trac.wordpress.org/ticket/24044

You don’t need this plugin if you run WP >= 5.3

Add Index To Autoload Plugin

This tool will speed up your database queries by adding an index to the “autoload” field.
With this index the query time for the autoload option will not increase with growing table size.
Therefore it helps speeding things up – especially with big option-tables.

Plugin-Overview

This plugin offers four options:

  • A one-click check mechanism to check if indexes on the autoload field exist
  • An option that adds an index to the autoload field
  • One-click index removal
  • Adding a simple wp-cronjob, that periodically checks if the index still exists and notifies you, if it doesn’t.

Support

If you encounter any issues, please leave a support ticket on the WordPress.org Forum

Bug reports

Bug reports for this Plugin are welcomed on GitHub.
Please note GitHub is not a support forum, and issues that aren’t properly qualified as bugs will be closed.

From within WordPress

  1. Visit ‘Plugins > Add New’
  2. Search for ‘Add Index To Autoload’
  3. Activate Add Index To Autoload from your Plugins page.
  4. Go to “after activation” below.

Manually

  1. Upload the add-index-to-autoload folder to the /wp-content/plugins/ directory
  2. Activate the Add Index To Autoload through the ‘Plugins’ menu in WordPress
  3. Go to “after activation” below.

How to

  1. After activation you should see a new subpage under Tools > Add Index To Autoload
  2. Backup your WordPress database (optional but recommended!)
  3. Go to the “Options” Section below and click the Add Index button
  4. Click the Check button: You should see a success message after a couple of seconds.
    4a. If you don’t, please issue a support ticket on the WordPress.org Forum
  5. Specify a periodic check for the autoload field (optional but recommended!)

螢幕擷圖

  • Screenshot of the management page of the plugin.

常見問題集

Can this plugin break my database?

We have tested this plugin on +10000 WordPress-sites and on none did this plugin break anything.
But, we still recommend to backup your WordPress website, before using it.

使用者評論

2019 年 9 月 27 日
Finally a Index Autoload for our growing database, a nice and easy way to speed up the queries.
2019 年 2 月 5 日
Finally, a working plugin that adds the index automatically. Hope to see this on upstream WP core anytime soon.
閱讀全部 2 則使用者評論

參與者及開發者

以下人員參與了開源軟體〈Add Index To Autoload〉的開發相關工作。

參與者

將〈Add Index To Autoload〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

1.1.1

  • Update: Checked with WordPress 5.7

1.1

  • Added a check if the WordPress version is >= 5.3 if so, display a notice, that this plugin is not needed.

1.0

  • Initial release