Only ADK. Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: "lucianomt" <[email protected]> To: <[email protected]> Sent: Monday, May 18, 2009 11:16 PM Subject: [amibroker] Re: ODBC + DDE
> Tomasz, thank for the prompt response. I currently don't need millisecond > latency as my trades are not high frequency in nature. > Anything under a few seconds is fine. Would you recommend using either the > native DDE plug-in or ADK? > > > > > --- In [email protected], "Tomasz Janeczko" <gro...@...> wrote: >> >> SQL database & ODBC is wrong path for high-perf RT. >> >> ODBC is rather slow as it was never designed by Microsoft to be used as a >> real-time streaming tool. >> Also all standard SQL databases are way too slow for real time applications. >> >> Only proprietary binary low-level dbs like AmiBroker own, that are very low >> level and not SQL based >> are able to offer right speed. >> >> As for interfaces - only direct APIs (like AmiBroker Dev Kit) that operate >> directly >> on binary data via direct pointers and no need for copying data and without >> SQL overhead are fast enough. >> >> For commercial databases that offer better performance than SQL see Berkeley >> DB >> http://www.oracle.com/database/berkeley-db/db/index.html >> >> (Read their white papers that explain why all relational, sql-based >> databases are simply too slow) >> >> Best regards, >> Tomasz Janeczko >> amibroker.com >> ----- Original Message ----- >> From: "lucianomt" <lucian...@...> >> To: <[email protected]> >> Sent: Monday, May 18, 2009 6:30 PM >> Subject: [amibroker] ODBC + DDE >> >> >> >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 >> > >> > >> > >> > > > > > ------------------------------------ > > **** 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 > > >
