Re: Solr filter using data from the database

2012-11-20 Thread Mikhail Khludnev
Hello Colleagues, Recently I had talk at ApacheCon about this problem. Both proposed approaches are definitely work. Frequent updates http://goo.gl/xGPMUsometimes cost too much. Filters http://goo.gl/mMvRQ works slow starting from thousand of keys and might have low hit ratio. One of the promising

Re: Solr filter using data from the database

2012-11-16 Thread Otis Gospodnetic
Hi, I'm actually not sure what Wunder is suggesting, but here is another way. Have an external app that talks to the DB either on demand or every N minutes/hours. When it talks to the DB it gets all merchants whose visibility flag was changed one way or the other since the last time the app check

Re: Solr filter using data from the database

2012-11-16 Thread Walter Underwood
Create an HTTP call backed by the database to fetch the list of valid vendors. Mark that response cacheable until the next refresh. Use an HTTP cache in case the database is temporarily unavailable. You don't really need a custom filter, you can list all the valid vendors in the filter query. T