I'm finding it an difficult task to maintain a database of stock prices. My main problem is how to efficiently handle splits and dividends. Is it better to handle this in a database with adjusted price columns or to do it in memory after fetching the data? Doing SQL row updates can be quite slow. I'm thinking it may be easier to handle it in the backtesting software itself rather than constantly updating a database.