Hello, i want to permit user to store their objects with price in their preferred currency. this is not a big problem, but i also want to permit users to search among all the object in their currency
Ex : i want all object with price > 100 USD or i want all object with price > 100 EUR How do you handle this ? actually i store all the value in EUR in the database with a field EUR2CurrencyRate ... and every week i update the value in EUR with the new exchange rate. it's too much intensive as i need to scan every week all the database to update all the value that was not filled in EUR
