[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Speed issues with Premium Data



PureBytes Links

Trading Reference Links

Hello,
 
It works for OHLC and Volume records for any data source. So it does not cover other fields that you may have in your SQL database. On the other hand
MySQL has its own internal caching mechanism.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
Sent: Friday, April 11, 2008 5:09 AM
Subject: Re: [amibroker] Speed issues with Premium Data

Tomasz, does this procedure of putting the tickers into RAM work for SQL databases, as well?  Or, does it not work because we cannot use the Local Database type?  Thank you.
 
 
----- Original Message -----
Sent: Thursday, April 10, 2008 1:05 PM
Subject: Re: [amibroker] Speed issues with Premium Data

Yes, for best results increase both, however do not enter more than your RAM size is because then Windows would swap to hard disk anyway.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: ges x
Sent: Thursday, April 10, 2008 9:44 PM
Subject: Re: [amibroker] Speed issues with Premium Data

Thank you, Tomasz, I'll try that.  Do I also need to change the "in memory cache size (max. symbols)"?

The PremiumData database with all the backlisted symbols is huge, so maybe I just haven't sized the data preferences big enough.

ges


On Thu, Apr 10, 2008 at 12:59 PM, Tomasz Janeczko <groups@xxxxxxxxxxcom> wrote:

If you want caching and faster use of MS databases, go to File->Database Settings
and change "Local database storage" to "Enabled", also you may go to
Tools->Preferences->Data and increase 'in-memory cache'.

Best regards,
Tomasz Janeczko
amibroker.com


----- Original Message -----
From: "ges" <ges8ges@xxxxxxcom>
To: <amibroker@xxxxxxxxxps.com>
Sent: Thursday, April 10, 2008 8:36 PM
Subject: [amibroker] Speed issues with Premium Data

> I've used QuotesPlus with AB for quite a while and just got
> PremiumData's historical data and delisted data and am having speed
> problems with PremiumData.
>
> With QuotesPlus, after the first run of an exploration or backtest, AB
> keeps the data in memory and subsequent runs are very fast and there
> is not the constant disk access to bog the computer down when doing
> other tasks.
>
> With PremiumData I can't get the same behavior. Is this because the
> PremiumData data is in Metastock format? Or is it my database settings?
>
> I have tried changing the database settings every way I can think of,
> but I can't get AB to handle the PremiumData the same speedy way that
> id does QP data.
>
> Is there some change to database prefs/settings that will allow AB to
> keep the PremiumData in memory or is this just a limitation of the
> Metastock data format?
>
> Thanks for any suggestions.
>
> ges
>
>
> ------------------------------------

>
> Please note that this group is for discussion between users only.
>
> To get support from AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroker.com/devlog/
>
> For other support material please check also:
> http://www.amibroker.com/support.html
> Yahoo! Groups Links
>
>
>

__._,_.___

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___