[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: ODBC + DDE



PureBytes Links

Trading Reference Links

Do you have your main index (immovable) on symbol, date?  Made a big difference for me.

--- In amibroker@xxxxxxxxxxxxxxx, "lucianomt" <lucianomt@xxx> 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.
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/