: My initial approach was to grab the values (which are in another table) with a : DIH subentity and store them in a multivalued field, but that reduced index : speed to a crawl. That's because instead of one query for the entire import, : it was making an individual subquery for every document returned by the main : query. Switching to a left join, I couldn't see any performance difference, : and it's still one query.
It's not clera to me how you are getting the values i nthe first place that getting them as a multivalued field slowed down thta much, but if the data is already semi-colon delimited, then the RegexTransformer can make a mutlivalued field out of it using splitBy. -Hoss
