[Vtigercrm-developers] Time Interval workflow exhausts memory

[Rubén A. Estrada Orozco]

If so, there should be at least a warning message when selecting the "Time
Interval" option in workflows. Otherwise end users will get frustrated and
wonder why their workflows are not working properly.
Also, it would be a good idea to send an email to the admin user upon
vtigercron.php execution failure.

I hope Uma can read this and give some feedback.

Saludos

Rubén


On Thu, Feb 4, 2021 at 6:30 PM Sukhdev Mohan <s.mohan at myti.it> wrote:

> Si It does fall into create/update logic. My experience with vtigeer says
> that it can handle at most 5k records or little more. Afterwards you have
> an out of memory error.
>
>
> Il ven 5 feb 2021, 01:21 Rubén A. Estrada Orozco <rulotec1 at gmail.com> ha
> scritto:
>
>> It's a record update action.
>>
>> Saludos
>>
>> Rubén
>>
>>
>> On Thu, Feb 4, 2021 at 6:09 PM Sukhdev Mohan <s.mohan at myti.it> wrote:
>>
>>> What is the operation you are performing?
>>>
>>> Il ven 5 feb 2021, 01:06 Rubén A. Estrada Orozco <rulotec1 at gmail.com>
>>> ha scritto:
>>>
>>>> I'm actually using a regular Workflow:
>>>>
>>>> [image: image.png]
>>>>
>>>> No custom code involved whatsoever.
>>>>
>>>> Saludos
>>>>
>>>> Rubén
>>>>
>>>>
>>>> On Thu, Feb 4, 2021 at 5:54 PM Sukhdev Mohan <s.mohan at myti.it> wrote:
>>>>
>>>>>
>>>>>> Is it ok to increase the memory limit to say 1 GB?
>>>>>> any other tip or hint?
>>>>>>
>>>>>
>>>>> Bad idea. If you have to check/update the best is batch it at 5k and
>>>>> parallel create/update.
>>>>>
>>>>> In a project I had to read from a source, then create JSON files
>>>>> containg array of 5k objects and then call a script which accepted Entity
>>>>> and JSON file, and just decide and call the API. Of course it's not perfect
>>>>> as it takes a lot of time to finish (arround 20/30 Min for 22k records).
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> http://www.vtiger.com/
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210204/75108899/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 54136 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210204/75108899/attachment-0001.png>