by FibreCRM

Dynamic Target Lists for SugarCRM enables users to AUTO populate Target Lists based on one or more pre-defined conditions. This module keeps your Target Lists up to date and relevant.

Cancel at any time!
Free Trial

#4129 - Issue: off_quick2list_schedule db get too large.

Open Bug? created by leonell one month ago

Hi.

off_quick2list_schedule gets too large. Do you know when will this database get purge?

  1. fibrecrm member avatar

    FibreCRM Provider Affiliate

    one month ago

    Hi, if the table is getting too large then it's possible there are too many listing running and/or running to frequently that your CRM cant catch-up. how many records are you handling through quick 2 list? how frequently are they scheduled to run ?

  2. leonell member avatar

    leonell

    one month ago

    Hi, Below are the schedules we put and we are handling a thousand records in quick2list. Please advice an optimal frequency to handle a thousand records atleast.

    Quick2List Processing: As often as possible.
    Quick2List - Missed Queries: On the hour; Every 12 hours
    Quick2List Prospesct List Entry: As often as possible.

    • fibrecrm member avatar

      FibreCRM Provider Affiliate

      one month ago

      Hi thanks for this. how often have you set Quick 2 list run for target lists?
      such as all clients target list > add and remove every 5 minutes . how many records are being processed ? how many target lists are you using quick 2 list on ?

    • leonell member avatar

      leonell

      one month ago

      Quick 2 list run for target lists is running as often as possible. Add and remove.
      Records is around 1 thousand. Target list using quick 2 list is probably around 5-10.

  3. fibrecrm member avatar

    FibreCRM Provider Affiliate

    one month ago

    it sounds like the list cant process quick enough, can you change the frequency of the lists to only run every few hours and see if the table decreases.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.