vicidial.org

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

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.

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

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..

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.

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]