<t>This is more of a hack than good DB design but I have once seen a DB where price tables had 366 columns containing the data for each day of a year. It is quite ugly but can be much faster than having a typical 2 columns [date, value] structure.So it looks like:[year, value on day 1, value on day ...