Hello, hoping someone can point me to an efficient way of dealing with databases. Right now I have an historical database of a dozen symbols, going back 10 years on each symbol (1-min data). The database is too large for auto trading, as it causes AB to crash on WinXP. So what I want to do is have a separate database of the 12 symbols, but only containing the latest 10 days or so of data.
Database 1: large historical database of 12 symbols going back 10 years Database 2: small live database of 12 symbols with latest 10 days worth of data I would use Database 1 for backtesting purposes, and Database 2 for live trading. Creating Database 2 is easy. But what if I want to merge the two sets of databases every week, so that Database 1 is kept up to date with the latest data from Database2? Is there an easy way to merge symbols across two different databases, and perhaps even do this in an automated fashion? And what about trimming the data in Database 2 every week, so that it only ever contains a max of 10 days of data per symbol? Is there any easy way to "flush" data from the actual symbol? Would I simply use the Split option, or is there a more automated way of doing this?
