Subject How to store value in different currency ?
Author nathanelrick

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