Hi! After 1,5 days digging on google, solr wiki, solr 1.4 book (Smiley/Pugh), solr-user mailing list no solution turn up for my problem *sigh*.
I use: - solr 3.3 - Date Import Handler 3.3 - JDBC source is MySQL Constrains: - No changes to core database schema - I can only add new views, stored procedures/functions My Problem: Our users can set prices for their product as they wish, regardless of any currency conversion rate etc. These prices are stored in an extra table, a classic 1-N relation. ProductTable ProductID Name ... 1 Fairydust 2 Pot of Gold (rainbow not included) ... PriceTable ID ProductID Currency Price ... 1 1 EUR 3,99 2 1 CHF 2,22 3 1 USD 4,50 4 2 EUR 9999 5 2 GBP 3599 ... My indexed documents should contain following fields(columns), hence I want to do facets over currencies. Fairydust: ProductID Name EUR CHF USD Pot of Gold: ProductID Name EUR GBP Mutivalued fields wont work, because I need facets and I can't afford 192 columns in MySQL for all currencies supported by our software. Dynamic fields won't do the trick either as far as I know. I already solved this problem with early shoddy lucene prototype. I didn't need think twice. Do I need to switch to SolrJ and alike for this? If I switch to SolrJ do I suffer a panalty in index performance? I think DIH provide the solution for this problem but I can't find it. Any suggestions are welcome. Thanks for reading, Christian Bordis
