• Skip to main content
  • Skip to forum navigation

StudioPress

  • Shop for Themes
  • My StudioPress

Forum navigation

  • Home
  • General Genesis Discussions
  • StudioPress Themes
  • Genesis Blocks
    • Genesis Blocks
    • Genesis Custom Blocks
  • Retired Themes
  • FAQs
  • Forum Rules
  • Internationalization and Translations
  • Forum Bugs and Suggestions
  • Forum Log In

Are You Using The WordPress Block Editor?

Genesis now offers plugins that help you build better sites faster with the WordPress block editor (Gutenberg). Try the feature-rich free versions of each plugin for yourself!

Genesis Blocks Genesis Custom Blocks

AgentPress Listings Plugin – Query Performance Limitations and Optimizations

Welcome!

These forums are for general discussion on WordPress and Genesis. Official support for StudioPress themes is offered exclusively at My StudioPress. Responses in this forum are not guaranteed. Please note that this forum will require a new username, separate from the one used for My.StudioPress.

Log In
Register Lost Password

Community Forums › Forums › Archived Forums › General Discussion › AgentPress Listings Plugin – Query Performance Limitations and Optimizations

This topic is: not resolved

Tagged: Agentpress, AgentPress Listings

  • This topic has 4 replies, 3 voices, and was last updated 7 years, 10 months ago by 2fivedesigns.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • February 27, 2015 at 4:01 pm #142588
    ItsPhipps
    Member

    Hi,

    I'm currently in the process of looking into several different solutions to rebuild my real estate website. And the more and more I think about the advantages of using WordPress and having the listing information in my database, the more I feel like I want to try it out. I'm really tired of switching between different providers, and feel like having full control over my site and data is best (obviously).

    So, I have a setup that can push all the listing data from my market into my WordPress database. While it sounds like a slam dunk, I know that it's never as easy as it looks on the surface.

    THE PROBLEM

    The biggest thing that concerns me is the performance limitations of using CPT's in WordPress, and querying the listings in a search. Currently, my market has about 7,500 active listings. I know that 7,500 can probably easily be handled by WordPress, but this number can easily grow into the several hundreds of thousands of listings if I add sold data, and branch into one or two markets close by.

    FIRST QUESTIONS

    So what are the limitations of using AgentPress Listings for this?
    When can I expect to run into problems with slow searches?
    How can I optimize my setup to run everything as efficiently as possible?

    TAXONOMIES VS META

    One more thing.

    As I understand it, WordPress is more efficient when using Taxonomies to query large sets of data than it is with using Postmeta. If this is true, does that mean I should use taxonomies for the data most commonly used to search with, and just use postmeta for other misc data and anything I want to order results by?

    Here's my thoughts on this:

    Taxonomies

        State
        City
        Zip
        Bedrooms
        Bathrooms

    Postmeta

        Price
        Address
        All other listing details

    FINAL QUESTIONS

    Is this the best way to structure things, and is this the way AgentPress Listings works out of the box?
    Is AgentPress Listings and WordPress capable of sufficiently handling this task?
    Or should I do the extra work and use something like Pods so I can build a new set of database tables specifically for listings?

    Thank You for the help in advance!!!

    https://wordpress.org/plugins/agentpress-listings/
    February 27, 2015 at 11:18 pm #142628
    ItsPhipps
    Member

    Maybe I was off base with the thought of using Taxonomies for bedrooms and bathrooms. Here's what Ron Rennick said on the wordpress support forums for the plugin:

    Taxonomies and terms are strings and aren't suitable for range queries.

    https://wordpress.org/support/topic/selecting-a-range-of-taxonomies-manually-enter-range

    March 10, 2015 at 12:45 pm #143933
    JayM
    Member
    This reply has been marked as private.
    March 10, 2015 at 11:40 pm #143969
    ItsPhipps
    Member

    Seems like a small world we're living in Jay!

    I was hoping we could get an opinion from Carrie Dils (hopefully she has Google alerts set up lol), or somebody else who is familiar with the AgentPress Listings plugin to chime in with a little guidance.

    March 31, 2015 at 9:10 am #146255
    2fivedesigns
    Member

    I am looking into the same thing right now for a client and was wondering the same thing. Have you came up with a solution as of yet? Will you be using any type of IDX search plugin?

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • The forum ‘General Discussion’ is closed to new topics and replies.

CTA

Ready to get started? Create a site or shop for themes.

Create a site with WP EngineShop for Themes

Footer

StudioPress

© 2023 WPEngine, Inc.

Products
  • Create a Site with WP Engine
  • Shop for Themes
  • Theme Features
  • Get Started
  • Showcase
Company
  • Brand Assets
  • Terms of Service
  • Accptable Usse Policy
  • Privacy Policy
  • Refund Policy
  • Contact Us
Community
  • Find Developers
  • Forums
  • Facebook Group
  • #GenesisWP
  • Showcase
Resources
  • StudioPress Blog
  • Help & Documentation
  • FAQs
  • Code Snippets
  • Affiliates
Connect
  • StudioPress Live
  • StudioPress FM
  • Facebook
  • Twitter
  • Dribbble