Make sense, but still not sure exactly what's going on. Do you want it
to never stop crunching 50 records at a time? Once it finishes all 25
million, start again? Or is it a one and done deal?

I would have it run in it's own thread. For Lasso 9, I would either use
a thread object
(http://lassoguide.com/language/threading.html#thread-objects) to force
the code to only be run in one thread, or use [split_thread]
(http://lassoguide.com/language/threading.html#splitting-threads) to
spawn off as many concurrent threads of the code as you need.

The basic concept is to call something that sets up the work to be run
in the background. The trick is to recover gracefully from crashes.

Hopefully this points you in the right direction, but I'm sure it raises
some questions too.

Brad


On 9/30/13, 3:46 PM, John Morris wrote:
> I need to run a section of code on 25 million records.
>
> So, I currently have a page that finds the 25 million records, and then 50 at a time, I run some code, preforming more searched and updates and other stuff.
> Depending on other data for the found set, this set of 50 records could be done in 10 seconds, or it could be done in 2 minutes.
>
> I currently have it scheduled to run my page of 50 records every 3 minutes.
> What I want to change is to make it run, and it will "Crunch" that set of 50, then once it's done, not sit still for 2 minutes& 50 seconds, but to start on the next set.
>
> Does that explain it a bit better?
>
> - John Morris
>
> On Sep 30, 2013, at 2:37 PM, Brad Lindsay<brad@monkware.com> wrote:
>
>> Not sure I understand - when do you need to schedule it to run? Is it that a page takes a long time to load and you'd like to just let it do its task in the background? Or is there some sort of queue that you have that needs to be checked periodically for work to do? A little more details on the setup would be helpful
>>
>> Thanks,
>> Brad
>>
>> On 9/30/13, 3:33 PM, John Morris wrote:
>>> Make that Lasso 9, not 8.5
>>> Any code example in L9 would be great :)
>>>
>>> - John Morris
>>>
>>> On Sep 30, 2013, at 2:28 PM, John Morris<lists@sterling-databases.com> wrote:
>>>
>>>> Hey All,
>>>>
>>>> I was chatting w/ Bil at the conference, and he shared with me the way he would do this, I wrote down the tags he mentioned, and I can't find them now!
>>>>
>>>> So, I'll ask again :)
>>>>
>>>> I have a task that takes a while to run.
>>>> Every set of 50 records I need to process can take anywhere from 10 seconds to over 2 minutes.
>>>>
>>>> I want to schedule this process, but timing is bad.
>>>> Scheduling it every 3 minutes, is a waist of time, but some times it needs that much time.
>>>>
>>>>
>>>> Bill mentioned making my page run indefinitely in a loop.
>>>>
>>>> With the combination of Lasso_ExecutionTimeLimit, and Thread_Priority_High, and =85.. some_other_tag_I_cant_remember
>>>>
>>>> And code example would also be helpful.
>>>>
>>>> Thanks
>>>>
>>>> - John Morris
>>>>
>>>>
>>>> #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> Lasso@lists.lassosoft.com
>>>> To unsubscribe, E-mail to:<Lasso-unsubscribe@lists.lassosoft.com>
>>>> Send administrative queries to<Lasso-request@lists.lassosoft.com>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> Lasso@lists.lassosoft.com
>>> To unsubscribe, E-mail to:<Lasso-unsubscribe@lists.lassosoft.com>
>>> Send administrative queries to<Lasso-request@lists.lassosoft.com>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> Lasso@lists.lassosoft.com
>> To unsubscribe, E-mail to:<Lasso-unsubscribe@lists.lassosoft.com>
>> Send administrative queries to<Lasso-request@lists.lassosoft.com>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso
> Lasso@lists.lassosoft.com
> To unsubscribe, E-mail to:<Lasso-unsubscribe@lists.lassosoft.com>
> Send administrative queries to<Lasso-request@lists.lassosoft.com>

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>