Thanks for the answers. I'll definitely change the schema, adding new fields to improve quality of results.
In the meanwhile I cannot throw away everything, because this is a production project. What I'm worried about is the size of this text field (about 4/5MB for each document). How can be big a text field? And what is the performances slowdown if it is so big. My idea is to add new fields with more or less relevance, depending from the content, and then reduce the size of big text field in the next days. Ciao, Vincenzo -- mobile: 3498513251 skype: free.dev > Il giorno 02 gen 2016, alle ore 15:20, Binoy Dalal <binoydala...@gmail.com> > ha scritto: > > Indexing the various columns of your database table as separate fields into > solr will allow for more flexibility in terms of filter queries, faceting > and sorting your results. If you're looking to implement such features then > you should definitely be indexing every table column as a separate solr > field. > Additionally, this will also allow for greater flexibility for which fields > you want to query and/or display to the user. > >> On Sat, Jan 2, 2016 at 7:13 PM Upayavira <u...@odoko.co.uk> wrote: >> >> Ask yourself what you want out of the index, how you want to query it, >> then the way to structure your index will become more clear. >> >> What sort of queries do you need to execute? >> >> Upayavira >> >>> On Sat, Jan 2, 2016, at 01:30 PM, Vincenzo D'Amore wrote: >>> Hi All, >>> >>> Recently I have started to work on an new project. I found a collection >>> where there are few documents (~8000), but each document has only a big >>> text field with about 4/5 MB. >>> >>> As far as I understood the text field is created by copying all the text >>> fields existing into a mssql table. So each row is transformed in a >>> document and all row fields are copied into a big text solr field. >>> >>> Now it seems obvious to me that rows fields should be copied into >>> different solr fields but I was curious to know what's the opinion of the >>> forum about this situation and what's the best approach to re-design the >>> collection. >>> >>> Bests, >>> Vincenzo >>> >>> -- >>> Vincenzo D'Amore >>> email: v.dam...@gmail.com >>> skype: free.dev >>> mobile: +39 349 8513251 >>> >>> >>> Ciao, >>> Vincenzo >>> >>> -- >>> mobile: 3498513251 >>> skype: free.dev > -- > Regards, > Binoy Dalal
