Chris, how did you do that at the first place. Migrating the Ami db to SQL or say, Berekeley DB kind of db.
Soham --- In [email protected], Tomasz Janeczko <gro...@...> wrote: > > Hello, > > AmiBroker's own database is designed with high speed quotation data > retrieval in mind, > while general-purpose databases are .... too general to offer comparable > speed. > > Best regards, > Tomasz Janeczko > amibroker.com > > On 2010-04-30 16:55, Chris DePuy wrote: > > > > > > I have done what you are suggesting, and Amibroker is capable is > > retrieving information from mysql (or any sql via odbc). > > My experience, however, is that retrieving high-resolution data from > > mysql (price and volume) into Amibroker is much slower than running it > > from Amibroker "natively." I cannot say exactly how slow as I haven't > > taken the time to study it, and I realize that mysql re-keying > > <http://www.experts-exchange.com/articles/Database/MySQL/3-Ways-to-Speed-Up-MySQL.html>and > > > > indexing > > <http://http://articles.sitepoint.com/article/optimizing-mysql-application/4>can > > > > change these speeds (I'm no expert on that topic), but anecdotally I > > can tell you its like 1/10th as slow. I attempted once to read a > > couple months of data of the NASDAQ-100 at the 5-second bar level and > > the Amibroker just froze as it tried to refresh the screen. I had to > > task-manager kill Broker.exe to get to the next step. > > To answer your question directly, though, you just use the odbc > > <http://www.amibroker.com/odbc.html> plugins (there are two of them - > > one to allow you to retrieve price and volume as you are asking and > > the other to allow more ad hoc retrieval of non price / volume data). > > I am successfully using mysql to retrieve non price/volume data and > > integrating it into price/volume data that is stored in amibroker's > > database. > > > > ----- Original Message ----- > > *From:* sohamdas <mailto:soham...@...> > > *To:* [email protected] <mailto:[email protected]> > > *Sent:* Wednesday, April 28, 2010 11:55 PM > > *Subject:* [amibroker] Migrating Database to MySQL > > > > Hi Tomasz, others > > > > I have a database complete with 5 years of intraday data,1min > > timeframe, in 1500symbols +. > > I would like to migrate this database to a generic MySQL > > database,so that I can stay platform independent. For reasons > > obvious, I wont be able to export each and every symbol and import > > it to SQL. > > > > a. I am seeking a easy way to achieve the same. > > b. How can we interface AMI with an external database. > > > > Help appreciated. > > > > > > > > > > >
