Solr (text) <> RDMBS (dynamic data) - best practies?

2008-05-06 Thread igrigorik
We're investigating migrating from an RDMBS to Solr to add text search support, as well as, offload the text storage from our RDMBS (which is arguably not designed for this kind of stuff).. While whiteboarding the basic requirements, we realized that we have some 'special' requirements: Basic set

Re: Solr (text) <> RDMBS (dynamic data) - best practies?

2008-05-06 Thread igrigorik
Otis Gospodnetic wrote: > AideRSS, eh, nice, welcome :) ;-) > > Since for 1) you will have to go to your DB, why not just store the > retrieved data somewhere (JVM, memcached...) and simply re-use it for 2? > * get query > * get data from DB for filtering > * store data from DB in cache > * run

Re: Solr (text) <> RDMBS (dynamic data) - best practies?

2008-05-08 Thread igrigorik
Thanks Ryan! ig ryantxu wrote: > >> >> * write response using custom response writer? (this may not be >> right, I'd have to check) that grabs the extra data from cache >> and includes it with each hit >> > > Not a custom response writer... use a custom QueryComponent to augment