Stock history recording and retrieval needs to be fixed about dalal-street-server HOT 4 CLOSED

The least flexible solution for part 2 is to simply have multiple tables for each interval. That way querying would be simply SELECT * from the right table with the right limits. But that will require storing duplicate data (not an issue because the storage will be small - if we assume the game lasts for 10 days running 6 hours each day, for interval of 1 minute we'll have about 6 x 60 x 10 = 3600 rows, and each row would store OHLC (Open High Low Close) integers, rowid, stockid, time and maybe something else that I'm missing. Overall each row will have 4 + 1 + 1 integers (4 bytes each) and a timestamp string (20 bytes). Overall each row will have 40-50 bytes. That's 180kb for one stock. If we have 30 stocks the space for the history will be only 5.4MB for 1min interval. With other intervals this could maybe grow to 20-30MB. That's not an issue at all.

The problem with that is that adding new intervals or something like that will be painful.

If we have only a single Stock history table querying becomes quite complex.

from dalal-street-server.

We can use a single table StockHistory (or any other name) where we store the details of each stock at one minute intervals. Now, to get the stock history at every N minute intervals, we use the following query

SELECT * FROM StockHistory WHERE MOD(ID, N) = 0;

Thus, storing stock history in a single table at one minute intervals will suffice.

Note that this assumes there will be no deletions or rollbacks. But there won't be any in this case. So we can use the above query safely.
@Ar-Sibi @thakkarparth007

from dalal-street-server.

@Ar-Sibi we'll go ahead with this.

from dalal-street-server.

Fixed by #108

from dalal-street-server.