So, this is what I was interested in after working on the project for about nine months.
We have a postgres database and we use sunspot on top of solr in the rails application.
I was not here when we decided to use solr, so I do not know why we chose it in the first place. Everything works fine for small datasets, but the real pain is when reindexing each record after saving.
This allows the index to become obsolete, and we end it in slow tasks. This makes us so far, but every time we decide to redo the index and how it is built, it takes more than 24 hours in production and makes our client angry.
Here I should note that we are looking for contact fields that have 255 characters at max. Most of them are only 25 characters. No PDF or word files, etc.
The ultimate goal is a quick search and automatic search. I also want us to fuzzy match the search. I want Bill Smith to fit Bilsmith and other things.
To do this, I am now setting up the index part in the contacts model. This works, but every time my boss adds a requirement on how Bill Smith should fit Bill Smith, I need to rebuild the index.
Is there any better thing to use here than solr? I wonder if there is a purpose for this. In the end, I would like to have a search with some of the same features and speed as google. (Not to that extent) But I need the index to be rebuilt quickly if I need the index at all.
15 30 .
, solr.
EDIT: : ? Cant postgres , ?