Assuming you create the view in such a way that it returns 1 row for each solrdocument you want indexed: yes
On Wed, Mar 10, 2010 at 7:54 PM, blargy <zman...@hotmail.com> wrote: > > So I can just create a view (or temporary table) and then just have a > simple > "select * from (view or table)" in my DIH config? > > > Constantijn Visinescu wrote: > > > > Try making a database view that contains everything you want to index, > and > > then just use the DIH. > > > > Worked when i tested it ;) > > > > On Wed, Mar 10, 2010 at 1:56 AM, blargy <zman...@hotmail.com> wrote: > > > >> > >> I was wondering if someone could be so kind to give me some > architectural > >> guidance. > >> > >> A little about our setup. We are RoR shop that is currently using Ferret > >> (no > >> laughs please) as our search technology. Our indexing process at the > >> moment > >> is quite poor as well as our search results. After some deliberation we > >> have > >> decided to switch to Solr to satisfy our search requirements. > >> > >> We have about 5M records ranging in size all coming from a DB source > >> (only > >> 2 > >> tables). What will be the most efficient way of indexing all of these > >> documents? I am looking at DIH but before I go down that road I wanted > to > >> get some guidance. Are there any pitfalls I should be aware of before I > >> start? Anything I can do now that will help me down the road? > >> > >> I have also been exploring the Sunspot rails plugin > >> (http://outoftime.github.com/sunspot/) which so far seems amazing. > There > >> is > >> an easy way to reindex all of your models like Model.reindex but I doubt > >> this is the most efficient. Has anyone had any experience using Sunspot > >> with > >> their rails environment and if so should I bother with the DIH? > >> > >> Please let me know of any suggestions/opinions you may have. Thanks. > >> > >> > >> -- > >> View this message in context: > >> http://old.nabble.com/Architectural-help-tp27844268p27844268.html > >> Sent from the Solr - User mailing list archive at Nabble.com. > >> > >> > > > > > > -- > View this message in context: > http://old.nabble.com/Architectural-help-tp27844268p27854256.html > Sent from the Solr - User mailing list archive at Nabble.com. > >
