I probably need to visualise my models: MobileInfo (1)------------------------------------(1...*) SellingItem
MobileInfo has many fields to describe the characteristics of a mobile phone model (color, size..). SellingItem is an "instance" of MobileInfo that is currently sold by a user. So in the ERD terms, SellingItem will probably have foreign key call MobileInfoId that references the primary key of MobileInfo. Now obviously, I need to index MobileInfo to support faceted browsing. How should I index SellingItem? The simplest way probably is to combile mobile phone specs in MobileInfo and and fields in SellingItem, and then index all of them. In this case, if I have 1000 SellingItems referencing a particular MobileInfo, I have to repeat the fields in MobileInfo a thousand times. On 9/13/06, Chris Hostetter <[EMAIL PROTECTED]> wrote:
: Because the mobile phone info has many fields (>40), I don't want to : repeatedly submit it to Solr. i'm not really sure what you mean by "repeatedly submit to Solr" or how it relates to haveing more then 40 fields. 40 fields really isn't that many. To give you a basis of comparison: the last Solr index i built from scratch had 47 <field> declarations, and 4 <dynamicField> declarations ...those 4 dynamic fields result in approximately 1200 'fields' in the index -- not every document has a value for every field, but the average is above 200 fields per document. -Hoss
-- Regards, Cuong Hoang
