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:[email protected]>
*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.
