Thanks Chris, will take into account the same
--- In [email protected], "Chris DePuy" <cde...@...> wrote:
>
> Soham,
>
> I didn't migrate from ami db to mysql, as I had tick level data in .csv
> format that i just imported to mysql, but the way you could do that is to
> export the data from amibroker to a .csv, then take the .csv (or .csv's) and
> move them to mysql. I believe the easiest way to do that is to create a
> simple .afl that includes the columns you want sent to mysql, then run
> aa/explore, then click FILE export, save as. A simple .afl example would be:
>
> Filter=1;
>
> AddColumn(O,"o",1.2);
>
> AddColumn(H,"h",1.2);
>
> AddColumn(L,"l",1.2);
>
> AddColumn(C,"c",1.2);
>
> AddColumn(V,"v",1.2);
>
> Both Tomasz and I have advised against this, however, for performance reasons.
>
> Chris
>
>
> ----- Original Message -----
> From: sohamdas
> To: [email protected]
> Sent: Tuesday, May 04, 2010 10:31 AM
> Subject: [amibroker] Re: Migrating Database to MySQL
>
>
>
> 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 <groups@> 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:sohamdas@>
> > > *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.
> > >
> > >
> > >
> > >
> > >
> >
>
