Xenforo Need the best setup for supporing 2 characters seach in XF

Hi there..

Have seen by other threads in here that we are a few xf admins with advanced setups. So, I have to ask this.

If I need to give my users accurate 2 characters search options what is in need to gain that? Not about XF itself but more about the backend stuff to support it. Is any mysql flavor DB enough to handle that or should I have something else?

The only requirement - must be able to install in a centminmod environment - not necessarily from a centminmod menu options - can do it manually if reguired.

I does not have to be speedy - I just wish to get accurate query results returned.

Hope to hear from some of you guys.

 

Wow - that results was fast returned.. I will try a little to 'mis use' your search function here. Do you have any stats about how huch indexes is growing to be handle 2 characters search vs 4-5 characters options?

 

Allright guys.. I got elasticsearch installed on my least important servers. Debian Wheezy. I have 8 GB ram to that, did edit /etc/default/elasticsearch and change ES_HEAP_SIZE to 2G and not those 50% as mention in file.

After install of missing java jre and elasticsearch start I tested it with curl - and got this:

Code:

root@hosting:~# curl http://127.0.0.1:9200
{
  "name" : "Cordelia Frost",
  "cluster_name" : "mt-xfsearch",
  "version" : {
    "number" : "2.1.1",
    "build_hash" : "40e2c53a6b6c2972b3d13846e450e66f4375bd71",
    "build_timestamp" : "2015-12-15T13:05:55Z",
    "build_snapshot" : false,
    "lucene_version" : "5.3.1"
  },
  "tagline" : "You Know, for Search"
}

Will now go to Xenforo to flash my visa card and buy this €65 expensive enhanced search add-on..

I still wish to hear from others..

 

And it works - XF backend show this and I do have very very good 2 characters search now..

Code:

Elasticsearch Server:
    http://127.0.0.1:9200/mtxfsearch

    Version:         2.1.1
    Documents:         6,197 (4 MB)
    Index Updates:         6,197 (0.0003 seconds average)
    Searches:         55 (0.0117 seconds average)
    Fetches: 34 (0.0015 seconds average)

    Note that statistics will be reset if Elasticsearch is restarted or if the index is temporarily closed.

 

Yes indeed - after some time with elastic running it now tells:

Code:

Elasticsearch Server:
    http://127.0.0.1:9200/mtxfsearch

    Version: 2.1.1
    Documents: 6,212 (3.9 MB)
    Index Updates: 6,445 (0.0003 seconds average)
    Searches: 435 (0.0060 seconds average)
    Fetches: 249 (0.0005 seconds average) 

Still don't have many post - but that will come in time.. I wish to say, I think this is the best investment I have done to my XF beside of XF itself of course.