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

Re: [amibroker] Why does it take so long to apply edits?



PureBytes Links

Trading Reference Links

I mean I copied my old AFL text and pasted into another chart in  
another sheet with a different chart ID.  All done in the formula  
editor.
Dennis

On Nov 28, 2007, at 8:54 PM, J. Biran wrote:

>
> Do you mean you copy/pasted from old .AFL file to a new .AFL
> file in a text editor?
>
> Joseph Biran
> ____________________________________________
> -----Original Message-----
> From: amibroker@xxxxxxxxxxxxxxx
> [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Dennis Brown
> Sent: Monday, November 19, 2007 5:45 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: Re: [amibroker] Why does it take so long to apply
> edits?
>
> Hello,
>
> I just wanted to let everyone know that I found how to fix
> this
> problem.  Somehow my chart had become corrupted in such a
> way that
> every edit I made would progressively add a little bit more
> to the
> time it took to "Apply Indicator".  I was up to 15 minutes
> today
> before I found it was not my AFL that was doing it.  AB
> Support tried
> my AFL and let me know that it was not the problem which got
> me
> looking in the right direction.  Copying my AFL to another
> sheet
> fixed the problem.  It actually takes less than a second to
> do this
> operation now.
>
> Best regards,
> Dennis
>
> On Nov 8, 2007, at 9:09 PM, Dennis Brown wrote:
>
>> Tomasz,
>>
>> Thank you for your response on the forum.  Since this
> problem seems
>> to have gone way beyond the purpose of the forum at this
> point, I am
>> switching to AB Support to debug this issue.  I have
> included this
>> whole thread as background with that email.
>>
>> But to answer your questions here for the completeness of
> this thread:
>>
>> Yes, I am talking about "Apply Indicator" taking so long
> and it did
>> not make sense to me either that it should take so long.
>>
>> If I do a "Verify syntax" it takes less than a second.
>>
>> Normal operation mode is .25 seconds and resulted in the
> following:
>>
>> 	Using constant volume bar mode resulted in an
> "Apply" time of 8.5
>> minutes.
>> 	Switching to daily mode resulted in an "Apply" time
> of 9.5 minutes --
>> so not an improvement.
>> 	Commenting out ALL 2700 lines of my AFL code
> resulted in an apply
>> time of 3 minutes.
>>
>> The Profiler runs instantly and shows .01 seconds
> execution time, but
>> consists of only 6 functions that are checked because most
> of the AFL
>> is conditionally executed in indicator mode only.
>>
>> I edited out my indicator mode wrapper and used the
> Profiler again.
>> This time it showed the results on the screen for about 2
> seconds,
>> then the window disappeared and none of the AB windows
> could be
>> selected, as if the profiler model dialog box was still
> open but now
>> invisible.  I was able to catch the AFL run time from the
> window
>> before it disappeared.  One time it said .45 seconds,
> another time it
>> was 1.1 seconds.
>>
>> I took screen shots of the Task Manager while it is doing
> an "Apply
>> indicator" and sent them along with my AFL code to the AB
> support
>> email.
>>
>> Thank you for all you do for us.
>> Best regards,
>>
>> Dennis
>>
>> On Nov 7, 2007, at 4:26 PM, Tomasz Janeczko wrote:
>>
>>> Dennis,
>>>
>>> If you speak about "Apply indicator" - it should be
> sub-second time.
>>> Minutes mean that something is wrong.
>>> "Applying indicator" executes the code for ALL bars with
> selected
>>> symbol and selected interval.
>>>
>>> Your formula needs to be doing some weird things if that
> takes that
>>> much time.
>>> Use built in Profiler (in 5.0.1) to find out which
> functions that
>>> you are using cause such long times.
>>>
>>> Other than looking at your formula I can only suggest to
> switch to
>>> daily interval when applying the code during editing.
>>>
>>> Best regards,
>>> Tomasz Janeczko
>>> amibroker.com
>>> ----- Original Message -----
>>> From: "Dennis Brown" <see3d@xxxxxxxxxxx>
>>> To: <amibroker@xxxxxxxxxxxxxxx>
>>> Sent: Wednesday, November 07, 2007 6:24 PM
>>> Subject: Re: [amibroker] Why does it take so long to
> apply edits?
>>>
>>>
>>>> Ok,
>>>>
>>>> This has totally frustrated me.  I am ready to abandon
> the built-in
>>>> AFL editor.  It is taking forever to debug code when I
> have to wait
>>>> 4-8 minutes for every typo.
>>>>
>>>> However, I need to keep my AB chart running while
> editing the AFL
>>>> (because my AB startup setup is complicated).
>>>>
>>>> Can I use an external editor as a *direct* replacement
> for the
>>>> built-
>>>> in editor?
>>>> Alternatively, is there a way to disable the checking
> done by the
>>>> AFL
>>>> formula editor when applying?
>>>> Actually the syntax checking is fast, it is what it does
> after that
>>>> that takes so long.
>>>>
>>>> Am I the only one who sees this problem?
>>>>
>>>> Best regards,
>>>> Dennis
>>>>
>>>> On Oct 30, 2007, at 10:21 AM, Dennis Brown wrote:
>>>>
>>>>> Tomasz,
>>>>>
>>>>> As time has gone on, I have increased the complexity of
> my AFL to
>>>>> 2500 lines and my database to 200K.  The time to apply
> edits has
>>>>> also
>>>>> gone up to 8 minutes even though I have wrapped the
> code so that
>>>>> most
>>>>> only executes in indicator mode.  Finally today I
> became frustrated
>>>>> enough to track down the offending AFL.  I started by
> commenting
>>>>> out
>>>>> my entire AFL.  Time to apply --4 minutes for 2500
> lines of
>>>>> comments!  I am at a loss for how to track down what is
> causing the
>>>>> long apply edits now.  Do you know how I might approach
> this?
>>>>>
>>>>> Best regards,
>>>>> Dennis
>>>>>
>>>>> On Sep 4, 2007, at 9:16 PM, Dennis Brown wrote:
>>>>>
>>>>>> Tomasz,
>>>>>>
>>>>>> Thank you for your insights.
>>>>>>
>>>>>> I wrapped my code today as you suggested below and in
> an earlier
>>>>>> post
>>>>>> today, so unwrapped are only the uncalled functions
> and a few
>>>>>> variables initialized to keep out syntax errors.  I am
> using a
>>>>>> 90,000
>>>>>> bar 5 second database, but the chart timeframe is run
> at about
>>>>>> 7,000
>>>>>> bars, and my complex loop processing is limited by
> parameter to
>>>>>> less
>>>>>> than 2,000 bars.  Changing that parameter to 200 bars
> reduces the
>>>>>> execution time from 1 second to .2 seconds, but as you
> suggested,
>>>>>> does not seem to have much affect on the apply time
> --which now
>>>>>> varies from 35 to 65 seconds.  I also tried different
> tickers with
>>>>>> fewer bars (30,000) and it did made the apply time
> longer.  So I
>>>>>> would say my edit apply time is no longer dependent on
> my database
>>>>>> size or AFL complexity.
>>>>>>
>>>>>> Even though I am glad to have under a minute apply
> time now, it
>>>>>> seems
>>>>>> as though there is still something else that is
> slowing it
>>>>>> down.  Do
>>>>>> any other possibilities come to mind?
>>>>>>
>>>>>> One thing that I noticed, is that it is a consistent
> 35 seconds to
>>>>>> apply when I start up AB and just do a lot of applies.
> Switching
>>>>>> symbols, more edits, enabling complex AFL sections,
> etc. cause the
>>>>>> time to lengthen up to the 55 second area and it does
> not go back
>>>>>> down until I quit AB.  I am guessing that these things
> take memory
>>>>>> that does not get released and it reduces the RAM
> available for
>>>>>> processing the apply.
>>>>>>
>>>>>> PS.  When I turn on ALL of my formula (enabled in
> sections with
>>>>>> multiple timeframes and indicators) it takes about 5
> seconds to
>>>>>> execute with all the speed-up tricks so far --which is
> why I am
>>>>>> obsessed with getting the most speed I can out of AFL
> by clever
>>>>>> programming tricks.
>>>>>>
>>>>>> Best regards,
>>>>>> Dennis
>>>>>>
>>>>>> On Sep 4, 2007, at 6:00 PM, Tomasz Janeczko wrote:
>>>>>>
>>>>>>> Dennis,
>>>>>>>
>>>>>>> If you are "applying" the code - it is for the first
> time
>>>>>>> executed
>>>>>>> with ALL bars, regardless of QuickAFL and
> SetBarsRequired
>>>>>>> settings.
>>>>>>>
>>>>>>> Now *if* your formula is complex and uses looping and
> you are
>>>>>>> using
>>>>>>> for example tick database with hundreds of thousands
> of bars
>>>>>>> it may take a while. Usually it is non-issue as
> people are not
>>>>>>> using such complex formulas.
>>>>>>> (1 second is *very* long for execution under normal
>>>>>>> circumstances.
>>>>>>> My formulas usually execute well below 0.1 sec).
>>>>>>>
>>>>>>> You may wrap your code into
>>>>>>>
>>>>>>> if( Status("action")==actionIndicator)
>>>>>>> {
>>>>>>> ...
>>>>>>> }
>>>>>>>
>>>>>>> and this will prevent this effect.
>>>>>>>
>>>>>>> Best regards,
>>>>>>> Tomasz Janeczko
>>>>>>> amibroker.com
>>>>>>> ----- Original Message -----
>>>>>>> From: "Dennis Brown" <see3d@xxxxxxxxxxx>
>>>>>>> To: <amibroker@xxxxxxxxxxxxxxx>
>>>>>>> Sent: Tuesday, September 04, 2007 11:25 PM
>>>>>>> Subject: [amibroker] Why does it take so long to
> apply edits?
>>>>>>>
>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> I have noticed that the time it takes to apply an
> edit to my
>>>>>>>> large
>>>>>>>> indicator AFL takes a long but variable amount of
> time.  It
>>>>>>>> might
>>>>>>>> take 15 seconds one time and 3 minutes another time.
> It usually
>>>>>>>> takes about 2.5 minutes to apply an edit, though if
> there is a
>>>>>>>> syntax
>>>>>>>> error, it comes back right away.  The AFL itself has
> an
>>>>>>>> execution of
>>>>>>>> about 1 second per pass and starts up right away
> from scratch.
>>>>>>>>
>>>>>>>> I was wondering if there were any general rules that
> I should be
>>>>>>>> aware of that would make applying edits faster and
> more
>>>>>>>> consistent?
>>>>>>>>
>>>>>>>> Another thing that is interesting is that if I click
> anywhere on
>>>>>>>> the
>>>>>>>> chart or UI while the edit is being applied, it runs
> even
>>>>>>>> slower,
>>>>>>>> and
>>>>>>>> always resets all the params.
>>>>>>>>
>>>>>>>> Insights anyone?
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>> Dennis
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> 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
>>>>>>>
>>>>>>> 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
>>>>>>
>>>>>> 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
>>>>>
>>>>> 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
>>>>
>>>> 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
>>>
>>> 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
>>
>> 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
>
> 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
>
> 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
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/