Title: MySQL Performance – New Feature Request
Last modified: April 8, 2017

---

# MySQL Performance – New Feature Request

 *  Resolved [mikepeace](https://wordpress.org/support/users/mikepeace/)
 * (@mikepeace)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/mysql-performance-new-feature-request/)
 * 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](https://wordpress.org/support/users/rayrutjes/)
 * (@rayrutjes)
 * [9 years ago](https://wordpress.org/support/topic/mysql-performance-new-feature-request/#post-9112629)
 * 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](https://wordpress.org/support/users/mikepeace/)
 * (@mikepeace)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/mysql-performance-new-feature-request/#post-9154795)
 * 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](https://wordpress.org/support/users/rayrutjes/)
 * (@rayrutjes)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/mysql-performance-new-feature-request/#post-9155013)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/search-by-algolia-instant-relevant-
   results_899beb.svg)
 * [Search by Algolia – Instant & Relevant results](https://wordpress.org/plugins/search-by-algolia-instant-relevant-results/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/search-by-algolia-instant-relevant-results/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/search-by-algolia-instant-relevant-results/)
 * [Active Topics](https://wordpress.org/support/plugin/search-by-algolia-instant-relevant-results/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/search-by-algolia-instant-relevant-results/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/search-by-algolia-instant-relevant-results/reviews/)

## Tags

 * [MariaDB](https://wordpress.org/support/topic-tag/mariadb/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [performance](https://wordpress.org/support/topic-tag/performance/)

 * 3 replies
 * 2 participants
 * Last reply from: [rayrutjes](https://wordpress.org/support/users/rayrutjes/)
 * Last activity: [8 years, 11 months ago](https://wordpress.org/support/topic/mysql-performance-new-feature-request/#post-9155013)
 * Status: resolved