MySQL Performance – New Feature Request

  • Resolved mikepeace

    (@mikepeace)


    7 years, 11 months ago

    First of all I am very impressed and excited to use th Algolia Search plugin.

    I installed this plugin on a WP real estate site with ~16,000 property listings.

    I then ran indexing and the MySQL database grew from 32mb to 89mb and caused a significant performance degradation to the page load speed.

    I would like to propose this plugin be modified to allow the setup of a second standalone dedicated MySQL database just for the Algolia plugin.

    This would allow the use of Algolia on extremely large sites without degrading page load speed and also provide the flexibility of using Amazon RDS Aurora, MariaDB or MySQL dedicated to specifically to Algolia.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor rayrutjes

    (@rayrutjes)

    Hi there,

    First of all sorry about the delay, we were working on our new release.
    Good news being that it addresses your issue.

    We don’t rely on custom post types anymore so you should be able from version 2.0.0 to re-index everything just fine.

    Let me know how it goes.

    Please note that given the amount of posts you have, using the re-index command for wp-cli could be a good idea in your case:

    wp reindex –all

    Cheers,

    Thread Starter mikepeace

    (@mikepeace)

    Hi Ray,

    Thanks for the good news and the improvements concerning custom post types.

    This is a related question How could I use a new standalone VM to perform the Algolia indexing on my WP real estate site ? I’m still shy of using the Algolia plugin on the same mysql database that contains my real estate listings. I was thinking maybe I could use a new hostname ‘search’, example: search.domain.com for the results. Thoughts ?

    Thanks!
    Mike

    Plugin Contributor rayrutjes

    (@rayrutjes)

    Hey Mike,

    Regarding your MySQL database, it should be fine with the new version of the plugin. We now mostly read data.

    Regarding the separation of concerns, you could definitely index content and create a custom UI by re-using existing Algolia indices on a separate domain.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL Performance – New Feature Request’ is closed to new replies.