Do you have a reasonable expectation that performance is going to be a problem? The reason I ask is that I'm always suspicious of efficiency arguments when "things are working fine". Unless and until you can confidently predict that you're going to hit a performance issue, do it the easiest way possible.
The same goes for space. Who cares if your data takes up a Gig of extra space by storing things twice? Of course you *do* care if you take up an extra 100G of space. It's hard to make recommendations that mean anything unless you fill in some of the space/time details you have/ expect to have, because the answer varies depending upon what you need/expect. Best Erick On Fri, Jan 30, 2009 at 10:08 AM, ilwes <onet...@mailinator.com> wrote: > > Hello, > > I googled, searched this Forum and read the manual, but I'm not sure what > would be the best practice for Lucene search. > > I have an e-Commerce application with about 10 mySQL tables for my > products. > And I have an Index (which is working fine), with about 10 fields for every > product. Is it a common way having the same data (title, description, tags, > paths to pictures, sold_counter..etc) redundant in my mySQL DB and in the > Index? And everytime I add a product, saving it to both? Would it not > reduce > the performance doing always things twice? > > What would be the best practice? > 1) Save it to both index and mySQL DB (as I'm doing right now). > 2) Save only searchable fields (title, description and tags) and an > product_id to index and use product_id to query everything else from DB? > 3) ..? > > Would be thankful for some hints and your experience. > > Thx, > ilwes > > p.s. btw. im working with Zend/PHP but this shouldn't have any impact on > this question > -- > View this message in context: > http://www.nabble.com/Best-Practice-for-Lucene-Search-tp21748839p21748839.html > Sent from the Lucene - Java Users mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org > For additional commands, e-mail: java-user-h...@lucene.apache.org > >
