Hello,
No, it does NOT take 3-4 seconds to load each ticker. Loading
(i.e. switching between symbols) is INSTANT.
It takes 3-4 to BACKFILL. That's huge difference.
Are you aware that you are on 256kbps connection. That means
that your fully saturated connection is able
to deliver about 25KB of data per second. Now do you
have any idea how much data is one day
of 1-minute data?
As far as I remember you are using IQFeed. It delivers data in
ASCII format.
Let's say single quote line is 100 bytes. Compressed it
is 50. Now there are 60 lines per minute and
480 lines per 8 hours. That's 24KB PER DAY PER SYMBOL of
1-minute data. That means
that it takes 1-second FULLY SATURATED your internet
connection to deliver 1-day worth of 1-minute data for one symbol.
That's physical limit of your internet
connection.
Yes there is a way to get it faster:
a) invest in better internet connection
b) subscribe to data source that allows those 500 symbols to
be streaming
c) run scan with wait for backfill PRIOR to market open. Once
you initialy scan all symbol
UNCHECK "wait for backfill" and scans will
fun blazing fast.
----- Original Message -----
Sent: Monday, July 14, 2008 11:02
PM
Subject: [amibroker] Speed the
database!?
Hi,
I have my 1-minute database setted with all my
tickers and everything, but damn it it is so slow! It takes like 3-4
seconds to load each ticker... Is there a way to make it run faster,
considering I don't need all the data when
exploring?
Thanks,
Louis