I am trying to set up real-time feeds on AB. I have a SQL database that contains all the necessary data. The only problem is the very high delay I get using the ODBC plug-in. To pull up about 1000 bars for 150 tickers takes approx. 10 minutes, which makes it impractical for real-time. (The same process using local database takes 1 second.)
So my first question is: am I doing something wrong? Is there any way to improve this performance significantly or is the ODBC solution inherently slow? If nothing can be done to improve ODBC, I thought I could upload the historical data into the local database and them use a different source, say DDE, to update the real-time quotes for the current day. Would that solution work? Please note that the historical data needs to be updated daily since it is a total-return series.
