# Need help with Sphinx integration **URL:** \ **Category:** Development\ **Created:** [2017年十月23日 16:55 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616 "2017-10-23T16:55:01Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![rornoob](https://avatars.discourse-cdn.com/v4/letter/r/7bcc69/32.png) [@rornoob](https://meta.discourse.org/u/rornoob)\ **Post date:** [2017年十月23日 16:55 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/1 "2017-10-23T16:55:01Z")
We want to transfer our site content to Discourse. For that we’ve setup a test site to check the performance of Discourse and find out that it’s built-in search is returning results very slowly (10 to 30 seconds) after loading 200K dummy topics. We are thinking to integrate [Sphinx](http://sphinxsearch.com). We are not that much knowledgeable on RoR, Docker and Discourse. If anyone here integrated Sphinx, please help/guide us. ---
**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\ **Post date:** [2017年十月23日 18:49 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/2 "2017-10-23T18:49:30Z")
With a lot of topics, you will need to enable the “search prefer recent posts” site setting. ---
**Author:** ![rornoob](https://avatars.discourse-cdn.com/v4/letter/r/7bcc69/32.png) [@rornoob](https://meta.discourse.org/u/rornoob)\ **Post date:** [2017年十月23日 19:44 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/3 "2017-10-23T19:44:03Z")
Hi Jeff, thanks for your fast reply. We already tried that option. Our site type is such users will search for the oldest posts more. Our current site has 1 million topics. We’re quite sure once we load that much data, built-in search won’t perform as expected. If you can just guide us towards right direction on how we can integrate Sphinx, it’d be a great help. We’re willing to pay if someone can do that. Please help us. Fast search is crucial for our site. Thank you again. ---
**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\ **Post date:** [2017年十月23日 20:29 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/4 "2017-10-23T20:29:33Z")
How much RAM does your server have? How fast is the CPU? Data is on SSD? ---
**Author:** ![rornoob](https://avatars.discourse-cdn.com/v4/letter/r/7bcc69/32.png) [@rornoob](https://meta.discourse.org/u/rornoob)\ **Post date:** [2017年十月23日 20:43 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/5 "2017-10-23T20:43:08Z")
Hi Jay, thanks for your reply. Our test server has 8gb RAM, 4 vCores (3.5 GHz) and storage is 80gb SSD. It’s a VPS server, not dedicated. We don’t know the processor model. Let me know if you need any other info. We really like Discourse and want to stick with it. Any help regarding the issue will be much appreciated. ---
**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\ **Post date:** [2017年十月23日 20:50 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/6 "2017-10-23T20:50:40Z")
And you did a [standard install](https://meta.discourse.org/t/142537?silent=true) using discourse-setup? ---
**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\ **Post date:** [2017年十月23日 21:08 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/7 "2017-10-23T21:08:32Z")
We don’t have any particular advice in this scenario. It is too bad “prioritize recent posts” doesn’t fit your use case. It does fit most discussion use cases we see, though, and you’ll note that Google itself puts a fair bit of weight on more recent content over very old content. ---
**Author:** ![rornoob](https://avatars.discourse-cdn.com/v4/letter/r/7bcc69/32.png) [@rornoob](https://meta.discourse.org/u/rornoob)\ **Post date:** [2017年十月24日 14:53 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/8 "2017-10-24T14:53:39Z")
Hi, Jay. Yes, we followed this to install Discourse: [discourse/docs/INSTALL-cloud.md at main · discourse/discourse · GitHub](https://github.com/discourse/discourse/blob/master/docs/INSTALL-cloud.md) Thanks for your reply. ---
**Author:** ![rornoob](https://avatars.discourse-cdn.com/v4/letter/r/7bcc69/32.png) [@rornoob](https://meta.discourse.org/u/rornoob)\ **Post date:** [2017年十月24日 14:59 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/9 "2017-10-24T14:59:21Z")
Hi Jeff, thanks for your reply. We already decided to stick with Discourse so we must find a way. We’re still working on this issue. Will update here if we overcome it. ---
**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\ **Post date:** [2017年十月24日 15:58 UTC](https://meta.discourse.org/t/need-help-with-sphinx-integration/72616/10 "2017-10-24T15:58:23Z")
I think what you need to do is to play around with the number of unicorn workers and the shared buffers and work\_mem of the database.