Re: Most efficient and scalable search strategy

2017-05-24 Thread Avraham Serour
take a look at the postgres fulltext search capabilities, I can't make any promises for your old postgres version another common approach is to index the search into elasticsearch and querying elasticsearch for the searches, it should handles misspellings and return the search results fast, but yo

Most efficient and scalable search strategy

2017-05-23 Thread Mike Dewhirst
Django 1.10, Postgres 9.1 (for the moment), Python 2.7 (for the moment) on Ubuntu 16.04 The search I need is an intersection hit. We have a substance model with fields for ... - name - molecular formula with subscripted unicode numbers - CAS number plus a Synonym model in 1:n with substance a