by Variance InfoTech Pvt Ltd

Email Software Integration helps you to connect your SuiteCRM Leads/Contact/Subscriber List with your favorite email marketing platforms. The following marketing platforms are supported: SendGrid, Mautic, Constant Contact, Active Campaign, SendIn Blue

Free 30 day trial
Try it Now

#4306 - Out of memory & timeout if contact database is large

Closed Bug? created by 2 years ago

My evaluate expired, I want to purchase it, however, there is a problem. Our contact database has more than 200, 000 row. Everytime doing the sync, it will either using up to 4G RAM and then timeout in 30 sec.

  1. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    2 years ago

    Hello,

    Apologies for the problem you're facing.

    Can you please check Request Timeout Settings on your Server from php.ini file.

    Also make sure you're using Batch Management feature because you've have large amount of data for Contacts Module.

    Regards,
    Variance Infotech PVT LTD

    • Roy member avatar

      2 years ago

      php.ini has increased the Memory to 5G and timeout also set to 300s, Batch has been set, but still have problem. Check that, it die when it get the full list from the Bean. Since the database is too large, it is not possible to get_full_list for the condition check.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      2 years ago

      Hello,

      Can you please tell me what is the size you have added in the Batch?

      Regards,
      Variance Infotech PVT LTD

    • Roy member avatar

      2 years ago

      Size try 1 to 20, still crashed. it crashed when the program trying to get_full_list in the condition comparing to get the total row.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      2 years ago

      Hello,

      Is it possible for you to share your CRM Login Credential and Server Credential where you hosted your CRM?

      If yes then please share on "techsupport@varianceinfotech.com". So we can check it from our end and you'll get quick solution.

      Regards,
      Variance Infotech PVT LTD

    • Roy member avatar

      2 years ago

      Sorry, the site has important information. But you could simpily generate a large data set like 200,000 row with 20 fields. It would takes more than 4G Ram and timeout.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      2 years ago

      Hello,

      We'll try to get records another way and see this problem occur again or not.

      Will provide you changes through email. Please share your email address.

      Regards,
      Variance Infotech PVT LTD

  2. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    a year ago

    Hello

    Thanks for your valuable support and being our customer. As per our last discussion related to ticket, hope you've received satisfied answer from our support team. For now, We're closing the ticket but if you've any questions or concern feel free to email us on techsupport@varianceinfotech.com or reply to the same ticket.

    Regards,
    Support Team Variance InfoTech Pvt Ltd

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