SugarCRM Integration

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

SugarCRM Integration

Postby covarrubiasgg » Fri Nov 12, 2010 8:26 pm

I was reading this thread:

http://www.vicidial.org/VICIDIALforum/v ... hp?t=14280

and i noticed that mike post this:

mflorell wrote:Keep in mind that Vtiger cannot store anywhere near as many leads as ViciDial can, which is why we didn't do leads sync. In our tests Vtiger became unusable at 100,000 leads, even with a dedicated DB server and web server.


Does anyone knows if the same happens with SugarCRM? currently i am doing research to migrate my old CRM and i was really considering Vtiger until i read mike´s post :P
covarrubiasgg
 
Posts: 420
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Postby mflorell » Fri Nov 12, 2010 11:09 pm

SugarCRM is actually slower than Vtiger if you can believe that. We have not tested performance of SugarCRM, but I'm sure if William is watching this thread he will chime in since he does a lot of work with Sugar.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: SugarCRM Integration

Postby TroyD » Tue Feb 15, 2011 10:51 pm

covarrubiasgg wrote:I was reading this thread:

http://www.vicidial.org/VICIDIALforum/v ... hp?t=14280

and i noticed that mike post this:

mflorell wrote:Keep in mind that Vtiger cannot store anywhere near as many leads as ViciDial can, which is why we didn't do leads sync. In our tests Vtiger became unusable at 100,000 leads, even with a dedicated DB server and web server.


Does anyone knows if the same happens with SugarCRM? currently i am doing research to migrate my old CRM and i was really considering Vtiger until i read mike´s post :P



I know this is an old post, but we have about 85,000 lead records with associated call records, attachments, notes, etc and it runs fast enough to keep up with the dialer. It is worth it to use the php accelerators and build some additional indexes to speed up Sugar a bit though. Worst case you can build a intermediate screen (like in .net or similar) to get whatever info from sugar you need at the time of the call then push it into Sugar via the backend database if Sugars web interface is not fast enough for you..
|3 Server - Cluster - WEB/DB/DIALER - ViciBox Install
|ASTERISK VER - Asterisk 11.25.1-vici
|AstGuiClient VERSION: 2.14-678a
|BUILD: 180613-0943
TroyD
 
Posts: 96
Joined: Fri Nov 02, 2007 4:03 pm

Postby williamconley » Tue Feb 15, 2011 11:41 pm

sugar's overlay (security so you don't take off their branding) does slow things down, but that seems to be a universal delay that does not increase based on sql record limit. since it rarely uses joins or complex sql statements, but does use mysql, it seems that sugarcrm has no more of a limit on records than vicidial does so far.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby mflorell » Wed Feb 16, 2011 12:19 am

We have noticed that adding custom fields seems to make things worse in Vtiger in terms of a performance hit. Especially when agents are doing searching by those custom fields and you have tens of thousands of records.
[/u]
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 30 guests