Do you have your main index (immovable) on symbol, date? Made a big difference for me.
--- In [email protected], "lucianomt" <lucian...@...> wrote: > > 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. >
