Skip to main content

ACF to Custom Database Tables Compatibility

Improve your filter performance in Divi Ajax Filter by enabling compatibility with the ACF to Custom Database Tables plugin. This integration allows your ACF field data to be stored in separate, optimized database tables, significantly speeding up filtering on sites with large datasets.

Plugin Requirement​

To use this feature, install the free ACF to Custom Database Tables plugin.

ACF to Custom Database Tables plugin Once installed and activated, a new Custom Tables menu item will appear under the ACF menu in your WordPress admin.

How to Enable Compatibility​

Step 1: Create a Custom Table for Your ACF Field Group​

  1. Go to Field Groups in your WordPress admin under ACF and edit an existing field group or create a new one.
  2. Scroll to the bottom of the field group page.
  3. Toggle on the ACF to custom database tables setting.
  4. Enter a custom table name using underscores to separate words (e.g., my_example_database).
  5. Save the field group.

Custom Table Toggle

Step 2: Generate the Table​

After saving:

  • Click the "Manage database tables" link at the top of the field group, or
  • Go to ACF > Custom Tables in the admin sidebar.
  1. Locate your new table in the list.
  2. Click Create Table under the Action column.
  3. Review the SQL query and click Create Table to confirm.

Create Custom Database Table

Step 3: Configure Divi Ajax Filter to Use the Custom Table​

  1. Open the page or template containing your Filter Posts module.
  2. Edit or add a Filter Post Module.
  3. For the filter item:
    • Set the Filter Type to Advanced Custom Field.
    • Select the appropriate Post Type and ACF Field Name.
  4. Toggle on Enable ACF Custom Table Query.
  5. Select the corresponding:
    • Database Table Name (e.g., my_example_database)
    • Column (the field in the custom table you want to filter)

Filter Posts Module custom database settings

Expected Results​

With this configuration enabled, Divi Ajax Filter will bypass the default WordPress meta queries and directly target your optimized custom table. This results in faster filter response times, especially on large datasets.

Limitations​

danger

This compatibility is not currently supported in Divi Machine or Divi BodyCommerce. Future updates may include support.

Last updated on