I am writing a tool that shows the price (and price change) of many markets, prices come from each other website and By the way, a mysql5 database is stored in:
table_market:
PK: timestamp | Base_currency | Quote_currency | Price
This means that I have 600 entries in 10 markets which are after one minute, which is very high. /.
So my idea is to gather the data: I want to accumulate the price for the last 5 minutes for every second old entries I want to collect data so 5 minutes is only one row 30 minutes For older entries I also want to collect them ..
So far I thought that to create a table for each market, but it will only divide things :( Mer The question is:
the real touch :)
Depending on the prices you are talking about, it would be better to save the data so that it changes. Therefore, keeping it in place of every other storage, store it only when it is different from the final price.
No comments:
Post a Comment