Hi Ahmed, fields that are empty do not impact the index. It's different from a database. I have text fields for different languages and per document there is always only one of the languages set (the text fields for the other languages are empty/not set). It works all very well and fast.
I wonder more about what you describe as "unrelated data" - why would you want to put unrelated data into a single index? If you want to search on all the data and return mixed results there surely must be some kind of relation between the documents? Chantal On Thu, 2010-07-29 at 21:33 +0200, S Ahmed wrote: > I understand (and its straightforward) when you want to create a index for > something simple like Products. > > But how do you go about creating a Solr index when you have data coming from > 10-15 database tables, and the tables have unrelated data? > > The issue is then you would have many 'columns' in your index, and they will > be NULL for much of the data since you are trying to shove 15 db tables into > a single Solr/Lucense index. > > > This must be a common problem, what are the potential solutions?