Hi, we are currently in the process of finding a solution for some performance issues we face when working with SugarCRM. On my local development environment I try to add tags to 100 accounts. I do this by first creating a specific amount of tags in the…

The goal of this sample code is to be able to create and update big amounts of data quickly, by leveraging only REST API for integration and initial data load purposes for on-site implementations. The code implements a POST based bulk upsert API for Sugar…

Hey! A client of ours is experiencing some weird slowness issue in Sugar 7.9 running on MySQL 5.7. The problem is caused by some of the sql queries taking an extremely long time which effectively causes many of them to get stacked. This in turn eats up…

Hello everyone ! What i want : Simply a fonctionnal Global search. What i have : Sugar Pro 7.5.1 My users need to search through Global Search, and we came to a strange situation : Even if i search the name of a contact (wich is high boost), in the global…

Hello Developers, I wrote a simple function that open a leads csv file and insert them into sugarcrm. there are 100,000 Leads in the file. and i loop through each row (using fget()) and create the lead bean and save() it works perfect! but as soon as…

I'm running Community 6.5 on a VPS with 1.8 cores Xeon and 7.5GB RAM and virtually nothing else intensive going on with the server. I think my my.cnf MySQL config is decent if the innodb buffer set to 2GB for one thing. I've seen some info out there about…

I received a question recently that I had to do some research to come up with answer. I'm sharing it here to wider community can benefit. My customer would prefer to have subpanel results come back sequentially instead of all at once. How do I disable…

We've been doing some testing of importing of Accounts, Contacts, and Leads into our SugarCRM install. We need to do a hard delete on all records we imported plus any related data (I do not know what this covers) It would be nice to have a near clean…