With many-to-many relationship between Category and Product we can go with multivalued Category field, or we can even have repeated values in Category&Point-of-Interest fields (_single_ valued); it's not necessary to store all fields in an index - you can store pointer to database Primary Key for instance.
001 Attraction CN Tower 002 Hotel CN Tower 003 Hotel Sheraton 004 Restaurant CN Tower Funtick wrote: > > Simple design with _single_ valued fields: > > Id Category Product > 001 TV SONY 12345 > 002 Radio Panasonic 54321 > 003 TV Toshiba ABCD > 004 Radio ABCD Z-54321 > -- View this message in context: http://www.nabble.com/big-discrepancy-between-elapsedtime-and-qtime-although-enableLazyFieldLoading%3D-true-tp18698590p18757613.html Sent from the Solr - User mailing list archive at Nabble.com.
