Also, when I right-click to change the time displayed, it takes 3-4 seconds and lot of loading... Any way to speed this?
Thanks, Louis 2008/7/16 Louis Préfontaine <[EMAIL PROTECTED]>: > Hi Tomasz, > > I am using data that has already been downloaded with QCollector. Hence, > I am running on a local database and what takes like 3-4 seconds is > scrolling through the 1-minute bars. Let's say it is Day 1 at 11:00 and I > want to scroll back to Day 0, I use my mouse wheel but for 3-4 seconds the > images does not move at all, then I hear my computer loading, then I see the > bars before. Is there a way to make that faster? > > Thanks, > > Louis > > 2008/7/15 Tomasz Janeczko <[EMAIL PROTECTED]>: > > 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. >> >> Best regards, >> Tomasz Janeczko >> amibroker.com >> >> ----- Original Message ----- >> *From:* Louis Préfontaine <[EMAIL PROTECTED]> >> *To:* [email protected] >> *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 >> >> >> > >
