SEO Auto Linker
Where do the keywords get stored? (4 posts)

  1. cemdev
    Posted 4 years ago #


    Where does this plugin store the keyword/urls? I can't find it in options, just the one general setting: pmg_autolinker_options

    What I would like to do is integrate the plugin with yoast's SEO plugin, since we're already specifying a focus keyword there, I'd like for this plugin to simply pick those up and work its magic. (love what it does!)

    I can make the modifications to the plugin, or we can run a batch job nightly that updates the data that this plugin uses, whichever is going to work out easiest really, but I can't find where this stores the data. Can you point me in the right direction please?




  2. chrisguitarguy
    Plugin Author

    Posted 4 years ago #

    Hi Chris,

    The "keywords" are actually just a custom post type (https://github.com/AgencyPMG/SEO-Auto-Linker/blob/0.7.1/inc/base.php#L7).

    So all the keyword lists and such are just stored in {$wpdb->prefix}_postmeta. They're all prefixed with seoal (https://github.com/AgencyPMG/SEO-Auto-Linker/blob/0.7.1/inc/base.php#L12)

    Here's the function that saves all the post meta: https://github.com/AgencyPMG/SEO-Auto-Linker/blob/0.7.1/inc/post-type.php#L248

    Does that help?


  3. Jason
    Posted 3 years ago #

    It seems like querying all the keywords would require a lot of database operations every-time a post is requested.

    (Pulling up a post queries ALL posts from that custom post type, no limits like posts are normally called with)

  4. chrisguitarguy
    Plugin Author

    Posted 3 years ago #

    It only pulls in keywords necessary for a given post type. Pulling up a post queries only the keywords associated with that post type.

    You can look at the query here.

    Additionally, you can limit the number of posts with a filter.

    If you're super concerned about it, suppress_filters is off for that query, and there are plenty of ways you can cache things. Or you can roll your own query.

    In short, I wouldn't worry about it. The plugin is fairly performant, and can be made more so with caching and the various filters it provides.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • SEO Auto Linker
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic