Support » Plugin: Relevanssi - A Better Search » Integrate Pods Advanced Content Type (ACT)

  • Resolved mewcrazy

    (@mewcrazy)


    Hello,

    Is it possible to integrate a custom table?

    The plugin Pods can create so called Advanced Content Types, which are based on a non-standard table in the wordpress database. Is it possible to integrate a custom table? Maybe through a filter/hook?

    The reason why I’m using those instead of a regular Content Post Type is that Ihave like 260,000 Entries with 15+ meta fields each. Using that amount with a regular CPT just kills the performance of WordPress. The table wp_post_meta alone had 4 million and more rows, each SELECT took up to 5-6 seconds.

    Dennis

    https://wordpress.org/plugins/relevanssi/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mikko Saari

    (@msaari)

    260 000 entries is way out of range for Relevanssi. You need something much more robust and efficient.

    Thread Starter mewcrazy

    (@mewcrazy)

    Hmm, well the entries don’t have any long texts. Basically it’s a post with 15 custom meta fields. Fields like age,gender,location,city etc. – Don’t you think that it might work with your plugin? Right now I have 15.000 products in regular CPTs and the search is blazing-fast. Feels even faster than the rest of the site.

    But if not, do you have any thoughts on what I could do in my case? I’m planning to have 1 million entries next year 😀

    Plugin Author Mikko Saari

    (@msaari)

    260 000 is way too much, no matter how small. Million, no chance. Relevanssi is built for the scale of thousands of posts, maybe tens of thousands in the best case.

    You need an industrial grade search solution. Swiftype? Solr? Something like that.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Integrate Pods Advanced Content Type (ACT)’ is closed to new replies.