Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted November 12, 201212 yr On next version of Sphinx , please make sure to allow us to keep Sphinx data on multiple indexes. Current implementation forces all data to be stored on one index and this index is really huge on big boards. I was suprised to see this honestly : -rw-r--r-- 1 root root 2690628 Nov 12 12:19 blog_comments_delta.spa -rw-r--r-- 1 root root 514067250 Nov 12 12:21 blog_comments_delta.spd -rw-r--r-- 1 root root 834 Nov 12 12:21 blog_comments_delta.sph -rw-r--r-- 1 root root 40708096 Nov 12 12:21 blog_comments_delta.spi -rw-r--r-- 1 root root 0 Nov 12 12:19 blog_comments_delta.spk -rw------- 1 root root 0 Nov 12 16:49 blog_comments_delta.spl -rw-r--r-- 1 root root 0 Nov 12 12:19 blog_comments_delta.spm -rw-r--r-- 1 root root 481490750 Nov 12 12:21 blog_comments_delta.spp -rw-r--r-- 1 root root 1 Nov 12 12:21 blog_comments_delta.sps -rw-r--r-- 1 root root 2690628 Nov 12 12:15 blog_comments_main.spa -rw-r--r-- 1 root root 514067250 Nov 12 12:17 blog_comments_main.spd -rw-r--r-- 1 root root 834 Nov 12 12:17 blog_comments_main.sph -rw-r--r-- 1 root root 40708096 Nov 12 12:17 blog_comments_main.spi -rw-r--r-- 1 root root 0 Nov 12 12:15 blog_comments_main.spk -rw------- 1 root root 0 Nov 12 16:49 blog_comments_main.spl -rw-r--r-- 1 root root 0 Nov 12 12:15 blog_comments_main.spm -rw-r--r-- 1 root root 481490750 Nov 12 12:17 blog_comments_main.spp -rw-r--r-- 1 root root 1 Nov 12 12:17 blog_comments_main.sps -rw-r--r-- 1 root root 0 Nov 12 12:12 blog_search_delta.spa -rw-r--r-- 1 root root 1 Nov 12 12:12 blog_search_delta.spd -rw-r--r-- 1 root root 712 Nov 12 12:12 blog_search_delta.sph -rw-r--r-- 1 root root 1 Nov 12 12:12 blog_search_delta.spi -rw-r--r-- 1 root root 0 Nov 12 12:12 blog_search_delta.spk -rw------- 1 root root 0 Nov 12 16:49 blog_search_delta.spl -rw-r--r-- 1 root root 0 Nov 12 12:12 blog_search_delta.spm -rw-r--r-- 1 root root 1 Nov 12 12:12 blog_search_delta.spp -rw-r--r-- 1 root root 1 Nov 12 12:12 blog_search_delta.sps -rw-r--r-- 1 root root 605400 Nov 12 12:12 blog_search_main.spa -rw-r--r-- 1 root root 94996301 Nov 12 12:12 blog_search_main.spd -rw-r--r-- 1 root root 712 Nov 12 12:12 blog_search_main.sph -rw-r--r-- 1 root root 13045146 Nov 12 12:12 blog_search_main.spi -rw-r--r-- 1 root root 0 Nov 12 12:12 blog_search_main.spk -rw------- 1 root root 0 Nov 12 16:49 blog_search_main.spl -rw-r--r-- 1 root root 0 Nov 12 12:12 blog_search_main.spm -rw-r--r-- 1 root root 66369288 Nov 12 12:12 blog_search_main.spp -rw-r--r-- 1 root root 1 Nov 12 12:12 blog_search_main.sps -rw-r--r-- 1 root root 0 Nov 12 07:42 core_tags_search_delta.spa -rw-r--r-- 1 root root 1 Nov 12 07:42 core_tags_search_delta.spd -rw-r--r-- 1 root root 553 Nov 12 07:42 core_tags_search_delta.sph -rw-r--r-- 1 root root 1 Nov 12 07:42 core_tags_search_delta.spi -rw-r--r-- 1 root root 0 Nov 12 07:42 core_tags_search_delta.spk -rw------- 1 root root 0 Nov 12 16:49 core_tags_search_delta.spl -rw-r--r-- 1 root root 0 Nov 12 07:42 core_tags_search_delta.spm -rw-r--r-- 1 root root 1 Nov 12 07:42 core_tags_search_delta.spp -rw-r--r-- 1 root root 1 Nov 12 07:42 core_tags_search_delta.sps -rw-r--r-- 1 root root 320 Nov 12 07:42 core_tags_search_main.spa -rw-r--r-- 1 root root 1230 Nov 12 07:42 core_tags_search_main.spd -rw-r--r-- 1 root root 553 Nov 12 07:42 core_tags_search_main.sph -rw-r--r-- 1 root root 1594 Nov 12 07:42 core_tags_search_main.spi -rw-r--r-- 1 root root 0 Nov 12 07:42 core_tags_search_main.spk -rw------- 1 root root 0 Nov 12 16:49 core_tags_search_main.spl -rw-r--r-- 1 root root 0 Nov 12 07:42 core_tags_search_main.spm -rw-r--r-- 1 root root 1 Nov 12 07:42 core_tags_search_main.spp -rw-r--r-- 1 root root 1 Nov 12 07:42 core_tags_search_main.sps -rw-r--r-- 1 root root 0 Nov 12 12:12 forums_search_archive_delta.spa -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_delta.spd -rw-r--r-- 1 root root 920 Nov 12 12:12 forums_search_archive_delta.sph -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_delta.spi -rw-r--r-- 1 root root 0 Nov 12 12:12 forums_search_archive_delta.spk -rw------- 1 root root 0 Nov 12 16:49 forums_search_archive_delta.spl -rw-r--r-- 1 root root 0 Nov 12 12:12 forums_search_archive_delta.spm -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_delta.spp -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_delta.sps -rw-r--r-- 1 root root 0 Nov 12 12:12 forums_search_archive_main.spa -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_main.spd -rw-r--r-- 1 root root 920 Nov 12 12:12 forums_search_archive_main.sph -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_main.spi -rw-r--r-- 1 root root 0 Nov 12 12:12 forums_search_archive_main.spk -rw------- 1 root root 0 Nov 12 16:49 forums_search_archive_main.spl -rw-r--r-- 1 root root 0 Nov 12 12:12 forums_search_archive_main.spm -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_main.spp -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_archive_main.sps -rw-r--r-- 1 root root 0 Nov 12 18:15 forums_search_posts_delta.spa -rw-r--r-- 1 root root 1 Nov 12 18:15 forums_search_posts_delta.spd -rw-r--r-- 1 root root 901 Nov 12 18:15 forums_search_posts_delta.sph -rw-r--r-- 1 root root 1 Nov 12 18:15 forums_search_posts_delta.spi -rw-r--r-- 1 root root 0 Nov 12 18:15 forums_search_posts_delta.spk -rw------- 1 root root 0 Nov 12 16:49 forums_search_posts_delta.spl -rw-r--r-- 1 root root 0 Nov 12 18:15 forums_search_posts_delta.spm -rw-r--r-- 1 root root 1 Nov 12 18:15 forums_search_posts_delta.spp -rw-r--r-- 1 root root 1 Nov 12 18:15 forums_search_posts_delta.sps -rw-r--r-- 1 root root 1283463440 Nov 12 09:18 forums_search_posts_main.spa -rw-r--r-- 1 root root 74374589748 Nov 12 12:12 forums_search_posts_main.spd -rw-r--r-- 1 root root 901 Nov 12 12:12 forums_search_posts_main.sph -rw-r--r-- 1 root root 24120575626 Nov 12 12:12 forums_search_posts_main.spi -rw-r--r-- 1 root root 0 Nov 12 09:18 forums_search_posts_main.spk -rw------- 1 root root 0 Nov 12 16:49 forums_search_posts_main.spl -rw-r--r-- 1 root root 0 Nov 12 09:17 forums_search_posts_main.spm -rw-r--r-- 1 root root 9530633595 Nov 12 12:12 forums_search_posts_main.spp -rw-r--r-- 1 root root 1 Nov 12 12:12 forums_search_posts_main.sps The sphinx we use on vBulletin have following structure and use way way less data -rw-r--r--. 1 sphinx sphinx 3548856 Nov 12 04:18 alphakeyword.spa -rw-r--r--. 1 sphinx sphinx 43190742 Nov 12 04:18 alphakeyword.spd -rw-r--r--. 1 sphinx sphinx 585 Nov 12 04:18 alphakeyword.sph -rw-r--r--. 1 sphinx sphinx 5571913 Nov 12 04:18 alphakeyword.spi -rw-r--r--. 1 sphinx sphinx 0 Nov 12 04:18 alphakeyword.spk -rw-------. 1 sphinx sphinx 0 Nov 12 04:18 alphakeyword.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 04:18 alphakeyword.spm -rw-r--r--. 1 sphinx sphinx 1662742 Nov 12 04:18 alphakeyword.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 04:18 alphakeyword.sps -rw-r--r--. 1 sphinx sphinx 147022272 May 25 01:26 alphapost.spa -rw-r--r--. 1 sphinx sphinx 1603822240 May 25 01:28 alphapost.spd -rw-r--r--. 1 sphinx sphinx 990 May 25 01:28 alphapost.sph -rw-r--r--. 1 sphinx sphinx 31644754 May 25 01:28 alphapost.spi -rw-r--r--. 1 sphinx sphinx 0 May 25 01:26 alphapost.spk -rw-------. 1 sphinx sphinx 0 Jun 19 10:12 alphapost.spl -rw-r--r--. 1 sphinx sphinx 0 May 25 01:26 alphapost.spm -rw-r--r--. 1 sphinx sphinx 432401526 May 25 01:28 alphapost.spp -rw-r--r--. 1 sphinx sphinx 1 May 25 01:28 alphapost.sps -rw-r--r--. 1 sphinx sphinx 50890224 Nov 12 04:15 alphathread.spa -rw-r--r--. 1 sphinx sphinx 476975982 Nov 12 04:15 alphathread.spd -rw-r--r--. 1 sphinx sphinx 822 Nov 12 04:15 alphathread.sph -rw-r--r--. 1 sphinx sphinx 31845915 Nov 12 04:15 alphathread.spi -rw-r--r--. 1 sphinx sphinx 0 Nov 12 04:15 alphathread.spk -rw-------. 1 sphinx sphinx 0 Nov 12 04:15 alphathread.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 04:15 alphathread.spm -rw-r--r--. 1 sphinx sphinx 11058251 Nov 12 04:15 alphathread.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 04:15 alphathread.sps -rw-r--r--. 1 sphinx sphinx 145266368 May 25 01:32 deltapost.spa -rw-r--r--. 1 sphinx sphinx 1797822700 May 25 01:36 deltapost.spd -rw-r--r--. 1 sphinx sphinx 990 May 25 01:36 deltapost.sph -rw-r--r--. 1 sphinx sphinx 37324929 May 25 01:36 deltapost.spi -rw-r--r--. 1 sphinx sphinx 0 May 25 01:32 deltapost.spk -rw-------. 1 sphinx sphinx 0 Jun 19 10:12 deltapost.spl -rw-r--r--. 1 sphinx sphinx 0 May 25 01:32 deltapost.spm -rw-r--r--. 1 sphinx sphinx 1613791694 May 25 01:36 deltapost.spp -rw-r--r--. 1 sphinx sphinx 1 May 25 01:36 deltapost.sps -rw-r--r--. 1 sphinx sphinx 155878016 May 25 01:41 gammapost.spa -rw-r--r--. 1 sphinx sphinx 2066749212 May 25 01:45 gammapost.spd -rw-r--r--. 1 sphinx sphinx 990 May 25 01:45 gammapost.sph -rw-r--r--. 1 sphinx sphinx 42156611 May 25 01:45 gammapost.spi -rw-r--r--. 1 sphinx sphinx 0 May 25 01:41 gammapost.spk -rw-------. 1 sphinx sphinx 0 Jun 19 10:12 gammapost.spl -rw-r--r--. 1 sphinx sphinx 0 May 25 01:41 gammapost.spm -rw-r--r--. 1 sphinx sphinx 2067073998 May 25 01:45 gammapost.spp -rw-r--r--. 1 sphinx sphinx 1 May 25 01:45 gammapost.sps -rw-r--r--. 1 sphinx sphinx 158533184 May 25 01:51 kappapost.spa -rw-r--r--. 1 sphinx sphinx 2115179057 May 25 01:55 kappapost.spd -rw-r--r--. 1 sphinx sphinx 990 May 25 01:55 kappapost.sph -rw-r--r--. 1 sphinx sphinx 48390301 May 25 01:55 kappapost.spi -rw-r--r--. 1 sphinx sphinx 0 May 25 01:51 kappapost.spk -rw-------. 1 sphinx sphinx 0 Jun 19 10:12 kappapost.spl -rw-r--r--. 1 sphinx sphinx 0 May 25 01:51 kappapost.spm -rw-r--r--. 1 sphinx sphinx 2119461037 May 25 01:55 kappapost.spp -rw-r--r--. 1 sphinx sphinx 1 May 25 01:55 kappapost.sps -rw-r--r--. 1 sphinx sphinx 158689856 May 25 02:01 lambdapost.spa -rw-r--r--. 1 sphinx sphinx 2092913938 May 25 02:05 lambdapost.spd -rw-r--r--. 1 sphinx sphinx 990 May 25 02:05 lambdapost.sph -rw-r--r--. 1 sphinx sphinx 92190559 May 25 02:05 lambdapost.spi -rw-r--r--. 1 sphinx sphinx 0 May 25 02:01 lambdapost.spk -rw-------. 1 sphinx sphinx 0 Jun 19 10:12 lambdapost.spl -rw-r--r--. 1 sphinx sphinx 0 May 25 02:01 lambdapost.spm -rw-r--r--. 1 sphinx sphinx 1920991374 May 25 02:05 lambdapost.spp -rw-r--r--. 1 sphinx sphinx 1 May 25 02:05 lambdapost.sps -rw-r--r--. 1 sphinx sphinx 9192 Nov 12 18:30 omegakeyword.spa -rw-r--r--. 1 sphinx sphinx 122064 Nov 12 18:30 omegakeyword.spd -rw-r--r--. 1 sphinx sphinx 585 Nov 12 18:30 omegakeyword.sph -rw-r--r--. 1 sphinx sphinx 121156 Nov 12 18:30 omegakeyword.spi -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 omegakeyword.spk -rw-------. 1 sphinx sphinx 0 Nov 12 18:30 omegakeyword.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 omegakeyword.spm -rw-r--r--. 1 sphinx sphinx 4745 Nov 12 18:30 omegakeyword.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 omegakeyword.sps -rw-r--r--. 1 sphinx sphinx 267648 Nov 12 18:30 omegapost.spa -rw-r--r--. 1 sphinx sphinx 3731048 Nov 12 18:30 omegapost.spd -rw-r--r--. 1 sphinx sphinx 990 Nov 12 18:30 omegapost.sph -rw-r--r--. 1 sphinx sphinx 704408 Nov 12 18:30 omegapost.spi -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 omegapost.spk -rw-------. 1 sphinx sphinx 0 Nov 12 18:30 omegapost.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 omegapost.spm -rw-r--r--. 1 sphinx sphinx 2820647 Nov 12 18:30 omegapost.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 omegapost.sps -rw-r--r--. 1 sphinx sphinx 10176 Nov 12 18:30 omegathread.spa -rw-r--r--. 1 sphinx sphinx 99858 Nov 12 18:30 omegathread.spd -rw-r--r--. 1 sphinx sphinx 822 Nov 12 18:30 omegathread.sph -rw-r--r--. 1 sphinx sphinx 112125 Nov 12 18:30 omegathread.spi -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 omegathread.spk -rw-------. 1 sphinx sphinx 0 Nov 12 18:30 omegathread.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 omegathread.spm -rw-r--r--. 1 sphinx sphinx 2042 Nov 12 18:30 omegathread.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 omegathread.sps -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 scankeyword.spa -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 scankeyword.spd -rw-r--r--. 1 sphinx sphinx 585 Nov 12 18:30 scankeyword.sph -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 scankeyword.spi -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 scankeyword.spk -rw-------. 1 sphinx sphinx 0 Nov 12 18:30 scankeyword.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 scankeyword.spm -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 scankeyword.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 scankeyword.sps -rw-r--r--. 1 sphinx sphinx 13824 Nov 12 18:30 scanpost.spa -rw-r--r--. 1 sphinx sphinx 313250 Nov 12 18:30 scanpost.spd -rw-r--r--. 1 sphinx sphinx 990 Nov 12 18:30 scanpost.sph -rw-r--r--. 1 sphinx sphinx 161365 Nov 12 18:30 scanpost.spi -rw-r--r--. 1 sphinx sphinx 1680 Nov 12 18:30 scanpost.spk -rw-------. 1 sphinx sphinx 0 Nov 12 18:30 scanpost.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 scanpost.spm -rw-r--r--. 1 sphinx sphinx 161782 Nov 12 18:30 scanpost.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 scanpost.sps -rw-r--r--. 1 sphinx sphinx 528 Nov 12 18:30 scanthread.spa -rw-r--r--. 1 sphinx sphinx 5437 Nov 12 18:30 scanthread.spd -rw-r--r--. 1 sphinx sphinx 822 Nov 12 18:30 scanthread.sph -rw-r--r--. 1 sphinx sphinx 8496 Nov 12 18:30 scanthread.spi -rw-r--r--. 1 sphinx sphinx 56 Nov 12 18:30 scanthread.spk -rw-------. 1 sphinx sphinx 0 Nov 12 18:30 scanthread.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 18:30 scanthread.spm -rw-r--r--. 1 sphinx sphinx 110 Nov 12 18:30 scanthread.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 18:30 scanthread.sps -rw-r--r--. 1 sphinx sphinx 146655104 May 25 02:11 sigmapost.spa -rw-r--r--. 1 sphinx sphinx 2012533816 May 25 02:14 sigmapost.spd -rw-r--r--. 1 sphinx sphinx 990 May 25 02:14 sigmapost.sph -rw-r--r--. 1 sphinx sphinx 102728330 May 25 02:14 sigmapost.spi -rw-r--r--. 1 sphinx sphinx 0 May 25 02:11 sigmapost.spk -rw-------. 1 sphinx sphinx 0 Jun 19 10:12 sigmapost.spl -rw-r--r--. 1 sphinx sphinx 0 May 25 02:11 sigmapost.spm -rw-r--r--. 1 sphinx sphinx 1761116802 May 25 02:14 sigmapost.spp -rw-r--r--. 1 sphinx sphinx 1 May 25 02:14 sigmapost.sps -rw-r--r--. 1 sphinx sphinx 115187648 Nov 12 04:16 thetapost.spa -rw-r--r--. 1 sphinx sphinx 1535342950 Nov 12 04:18 thetapost.spd -rw-r--r--. 1 sphinx sphinx 990 Nov 12 04:18 thetapost.sph -rw-r--r--. 1 sphinx sphinx 58015644 Nov 12 04:18 thetapost.spi -rw-r--r--. 1 sphinx sphinx 0 Nov 12 04:18 thetapost.spk -rw-------. 1 sphinx sphinx 0 Nov 12 04:18 thetapost.spl -rw-r--r--. 1 sphinx sphinx 0 Nov 12 04:16 thetapost.spm -rw-r--r--. 1 sphinx sphinx 1264745428 Nov 12 04:18 thetapost.spp -rw-r--r--. 1 sphinx sphinx 1 Nov 12 04:18 thetapost.sps
November 12, 201212 yr When you perform the search, you'd specify all of the indexes in vbulletin I assume? In that instance, sphinx itself is loading all of those indexes into memory and virtually "merging" them to perform the search anyways. Outside of file system filesize limits (which are an important factor), have you noticed any real difference in performance? It would seem on the surface that whether Sphinx looks at one big file, or 10 smaller files (that add up to the same size as the big file), it would have the same end result with the way Sphinx works.
November 12, 201212 yr Author IPB sphinx is 30-40% slower compared to Axivo Searchlight. Results are way more accurate and result return time is faster compared to IPB Sphinx. If you will like to test both , let me know so i can grant access to that. Keep in mind i am comparing a test server with no online user with an active site with thousands of online users. Additionally total index rebuild time is close to one hour , which means very very slow.
November 28, 201212 yr IPB sphinx is 30-40% slower compared to Axivo Searchlight. Results are way more accurate and result return time is faster compared to IPB Sphinx. If you will like to test both , let me know so i can grant access to that. Keep in mind i am comparing a test server with no online user with an active site with thousands of online users. Additionally total index rebuild time is close to one hour , which means very very slow. We haven't performed any comparative tests ourselves. We decided to use Solr for the forum search because we had experience with it, have you looked at or performed any tests on that?
November 28, 201212 yr We haven't performed any comparative tests ourselves. We decided to use Solr for the forum search because we had experience with it, have you looked at or performed any tests on that? All online comparisons I've seen of Solr vs Sphinx show Solr exponentially slower. I have not seen it in use with IPB to compare directly.
November 28, 201212 yr Author We haven't performed any comparative tests ourselves. We decided to use Solr for the forum search because we had experience with it, have you looked at or performed any tests on that? I didn't test Solr on IPB though i effectively tested it on Magento EE . Our tests clearly indicated that Sphinx is better on both performance and accuracy
November 28, 201212 yr Okay. Interesting to hear that. I'm not the one who made the choice about Solr myself, I have no knowledge about that or other search engines. But it's what we already had in use a lot of other places and members in our staff had experience with. Will speak with them on what their thoughts on Sphinx being better is and whether we would like to move away from it in the future or not. Thanks :smile:
December 10, 201212 yr All online comparisons I've seen of Solr vs Sphinx show Solr exponentially slower. I have not seen it in use with IPB to compare directly.Is this forum running on sphinx?
December 10, 201212 yr We are not using Sphinx here presently, no. Sphinx really isn't required (if you are only factoring in resource usage) until you have several hundred thousand posts, assuming you have a properly configured server with enough resources.
December 10, 201212 yr Brandon - this forum has over 1 million posts, and no Sphinx? Nice! My forum has 1.3 million posts and I have to use Sphinx. Does IPS plan on developing a more robust search engine? I don't like using third party add-ins if I don't have to.
December 11, 201212 yr We are not using Sphinx here presently, no. Sphinx really isn't required (if you are only factoring in resource usage) until you have several hundred thousand posts, assuming you have a properly configured server with enough resources.Why was it using it before? I thought this forum has enough posts to warrant it.
December 11, 201212 yr We are not using Sphinx here presently, no. Sphinx really isn't required (if you are only factoring in resource usage) until you have several hundred thousand posts, assuming you have a properly configured server with enough resources. or you need a good wildcard search, or a good acronym and 2 letter search
December 11, 201212 yr We are not using Sphinx here presently, no. Sphinx really isn't required (if you are only factoring in resource usage) until you have several hundred thousand posts, assuming you have a properly configured server with enough resources. It is required here. This community is the testing stage for releases, right? How exactly do you expect issues with sphinx search to be noticed, let alone fixed, if you do not use it here? Depending on the big boards/devs interested enough to bother to find bugs is asking for trouble. Example A fairly old bug, basically discovered inleu of mod support, that has quite apparently always been present. These blatantly obvious errors would be more easily found if you used sphinx here.
December 11, 201212 yr Why was it using it before? I thought this forum has enough posts to warrant it. The search routines have been improved since 3.0-3.2 so that they are more efficient. Additionally, our hardware was updated sometime during that time period if I recall correctly. or you need a good wildcard search, or a good acronym and 2 letter search Note I said if you are only factoring in resources. ;) Sphinx does have other benefits, yes. It is required here. This community is the testing stage for releases, right? How exactly do you expect issues with sphinx search to be noticed, let alone fixed, if you do not use it here? Depending on the big boards/devs interested enough to bother to find bugs is asking for trouble. Example A fairly old bug, basically discovered inleu of mod support, that has quite apparently always been present. These blatantly obvious errors would be more easily found if you used sphinx here. The vast majority of our users utilize MySQL search so it is MUCH more important to get live testing of THAT than live testing on our company forums of Sphinx, where a problem will affect a vastly smaller percentage of our clients. If we used Sphinx here, then there wouldn't be the live testing of MySQL searches, and frankly, that is far more important.
December 11, 201212 yr Back to the original topic, or at least close to. On my forum I use sphinx, not for performance but for functionality. I am happy with the most recent set of changes which allow search terms such as "c-160" where the mysql does not, but that functionality is not equally provided throughout the suite of products. Notably is downloads, where it is very inconsistent. While not disputing the need for user testing, I do feel that as a whole searching needs to have a lot of attention put on it and preferably with Sphinx, have the entire suite coded the same so searching is more effective and less erratic. I do have a bug tracker opened in downloads.
Archived
This topic is now archived and is closed to further replies.