SugarCRM Performance Extremes: Project SucraloCRM
SugarCRM software is designed to help business improve customer relationship management. The number of customers (and leads) varies widely from company to company and from industry to industry. A very successful company might have as few as 10 customers, while B2C companies might need to manage relations with millions or even tens of millions of customers (think Chinese or Indian telecom companies).
We will begin a series of posts that will take SuagrCRM to new performance extremes in regards to the number of objects it can handle, a project codenamed SucraloCRM (Sucralos is X600 more sweet then Sugar). The object we chose to focus on is Contacts, but the results of SucraloCRM will make SugarCRM better at handling any other objects - accounts, leads etc.
We will kick things off with a baseline benchmark. The performance figures we will show here will be used down the road for comparing our improvements and the influence of each configuration change on performance.
Open Source CRM Upcoming Releases
Writing software is an infinite cycle-you never actually finish building it. Imagine having to build a road that never ends. Since open source CRM solutions are relatively young (only few years old), there are numerous features customers want. Also, as part of any release, you have to improve performance, the user experience and even documentation. We will frequently take a look at what the major open source CRM vendors are planning for upcoming releases.
SugarCRM
Current SugarCRM release is 5.2. The major enhancement 5.2 offered was native mobile integration, including with the iPhone and Blackberry. Next release is 5.5 , planned for the summer of 2009, while a major release (6.0) is scheduled for the end of this year. 5.5 will include the following enhancements:
- You can build your own custom screens for wireless, from the sugarCRM studio (only in the Professional and enterprise editions)
- Records can be assigned to multiple teams (only in the Professional and enterprise editions)
- Improvements in web services - addition of a REST API (in addition to the SOAP API), more complex web service calls to minimize the number of calls being made and improved documentation
- Improved themes - easier to build and customize, separation of the presentation layer from the logic layer.
- Better password management - enforce password strength, password expiration, password reset and locking of users
- Additional native cloud connectors to web services, such as LinkedIn
OpenCX
- Ajax enhancement for improved user experience
- Improved scheduling, such as rooms reservations, car pooling etc.
- Export of object from OpenCRX, such as contact and calender items
- Improvement to the underlying Java infrastructure
- Enhanced mobile support - including the Google G1 smartphone
Installing SugarCRM On Linux With FastStack Installer
We recently wrote a tutorial on how to install SugarCRM on Ubunut Linux. That installation guide explained how to install all the different components (the entire LAMP stack) to run SugarCRM. Sugar also provides a much simpler installer, both for windows and Linux.
These types of installation wizards have been around for years under the windows platform, but are now becoming more and more popular on Unix/Linux. The problem with these installer on Linux is that there are sometimes slight variation between the different flavors and distributions, and it can be tricky to crate an installers that supports all platforms.
I used the FastStack installer on Ubnutu, and it worked like charm. If you have used the installer successfully on other Linux or Unix platforms, add your comment so we all know about that.
The installer has one useful advantage - it makes it very simple to install multiple SugarCRM instances on a single machine. You could use different directory and different ports to run as many SugarCRM instances as you like.
The installer is available to download from here.
Once the installer was downloaded, run the following command from the command line, from the directory where the installer was downloaded:
#chmod 755 sugarcrm-CE-5.2.0a-linux-installer.bin
#./sugarcrm-CE-5.2.0a-linux-installer.bin
The installer will initiate the installation process.
A license agreement will appear. Keep hitting enter (annoying!) until you get a Y/n question.
#Do you accept this license? guess I should… y
#Installation directory - you can use the default, or choose another directory
#Install phpMyAdmin - I think Y , this is very useful for managing your MySQL database
#Is this selection correct - of course.. Y
Typical or Custom - we’ll for typical, 1
#System name - input your company’s name or whatever
#Admin password - which password should I use ? my email? my facebook? generate a completely new one??
#Populate demo data - if this a production system, then NO!!, if this is for tests, ye, why not?
#Install service - if you want sugar to start automatically on machine start up, select Y
#Apache webserver post - you can choose default (80), but make sure no other http server is already listening on that port on your machine ( test with netstat -a | grep 80 or telnet hostname 80)
#SSL port - see above
#Web server domain - you better know what domain you are using. For tests on local machine, leave default
#MySQL server port - again, make sure there are no conflict with existing Mysql instances
#Mysql root password - it’s written on a note on the screen in front of you (kidding)
#Do you want to continue - why wouldn’t I??? Y
By now, the infamous Linux hashmarks trail should be racing across the screen. Go grab some coffee, it’s gonna be a long night.. (it should take about 2-3 minutes to complete). When it’s done, you’ll have a fully working CRM application!! how cool is that?
Best Performing Browser For SugarCRM Award Goes To…IE???
We ran a performance benchmark for browsers running SugarCRM, and Internet Explorer came out with the best results.You must be saying, Hey, wait a minute, Internet Explorer??? Come on, you must be doing something wrong..Firefox is much better, and Safari.. Well, we must admit we were surprised, but these are the results, we rechecked everything, and IE is the winner! The benchmark focused on communication between the browser and the SugarCRM server. Future benchmarks will measure rendering time of the pages returned from the Sugar server, and provide a more complete view on browser performance.
Benchmark Setup
We installed SugarCRM 5.2a Community Edition (we used the Linux binary installer) on an Ubuntu 8.04 machine. The hardware used to run sugar is an AMD Athlon 64 X2 Dual Core 3800+ CPU, with 2GB of RAM. The client machine, where we ran all the different browsers, was a windows XP on an Intel core 2 Duo @ 3.16 GHz, with 2GB of RAM machine. We used Webload from Radview to perform out performance tests. We tested 3 browsers:
- Microsoft Internet Explorer 7
- Firefox 3
- Apple Safari
Business Scnerio
The following business scenario was used for the performance testing:
- Login to SugarCRM
- Create a new contact
- List all Accounts
- Browse to last page in the accounts list
- Search for all accounts with a search string ‘a’
- View details of first result return by the search in step 6
- Logout of SugarCRM
Benchmark Process
Under each browser, we ran all steps of the business scenario outlined above. We then let Webload emulate the browsers for us, running 4 separate test for each browser, rebooting both the server and the client before each test run. In total, 12 runs were made. We measured a host of parameters, but focused our attention on two: response time and receive time. Without going into too many details, these parameters indicated how well the the browser communicates with the SugarCRM server. The lower the results - the better the communication.
Please remember that this test does not take into account the time each browser takes to render the page returned by the SugarCRM server. Different browsers use different rendering engines and rendering time is an important parameter in determining overall browser performance.
Results
Internet explorer was the fastest performing browser in the benchmark we conducted. Average response time for SugarCRM page requests (the more important parameter) was 0.1245 seconds, and average receive time was 0.0633. Firefox came in second with 0.258 and 0.056, respectively, and apple Safari finished last. Although IE registered the slowest recieve time, its Response time values were much better than other browsers. The results are summarized in the charts below:
Chart 1: Response time, in seconds, by browser
Chart 2: Recieve time, in seconds, by browser
Conculsion
This is the first of several Sugarcrm benchmarks Open Source Crm Guru plans to conduct. This benchmark provides a partial answer to the question ”which browser is best for SugarCRM“. The results today put Internet explorer in first place, but look for additional benchmark and final conclusions in upcoming posts. Register to our RSS feed to get the latest Sugarcrm benchmarks and news.
SugarCRM Head Up In the Cloud
Searchcrm had a very interesting interview with SugarCRM’s CEO, John Roberts. Roberts talks about the current situation and the future of the company, and focuses on 3 subjects: the economic slowdown, the cloud, and mobile. Not surprisingly, these are 3 of the hottest trends in the current business application realm: open source and cloud computing as the most viable option for business software in a slowing economy, and the future of business user interaction - the smartphone.
As was reported by Open Source ERP Guru, the entire open source business application industry is experiencing an impressive growth. Roberts explains the trend:
We’re seeing a big shift here to commercial open source as a more efficient and innovative method [of delivering applications]. This recession is certainly highlighting our value proposition versus our competitors. We’ve seen our product surge since Q3 of last year.
The big premise of commercial open source solutions is finally sinking into the minds of CIOs, who are faced with a very attractive option: get a fully functional, mature ,well tested CRM or ERP solution, without having to pay any license fees. “My CEO and CFO are gonna love me for that” , that’s what their thinking. That mindset is the wind powering the turbine of open source business applications recent growth.
The cloud has been around for many years, but the question was (and still remains) - how do business applications live so high, when CIO and IT people like to have their servers nearby, where they can control the application, the data, the servers? SalesForce.com took CRM out of the company’s server room and flew it right up to the cloud. That made things much easier for SugarCRM, who are generating 30% of their revenue from hosted SugarCRM instances. Numerous hosting providers offer their own SugarCRM services to other customers. Since there are so many services out there, in the cloud, integrating them into SugarCRM provides a lot of added value to customers:
As a customer, it’s great that you get these great data information services, and we’re partners with a lot, including Hoover’s, Jigsaw and LinkedIn, and others that are releasing their public APIs. At the same time, SugarCRM as a code base — because it is open — people are building all sorts of different cloud connectors to different information providers across the cloud.
A couple of days ago we wrote a post on SugarCRM mobile services. Roberts mentions the Sugar integration we discuss with the iPhone and Blackberry. Currently, solutions are available from 3rd part software vendors, but Sugar version 5.2 will have full support for these devices and other smartphones, according to Roberts. We look forward to testing this integration.
SugarCRM On Linux Install Guide
SugarCRM is the leading open source CRM solution, and one of the best available CRM offerings. Since it is an open source product, it’s freely available to download, install and use. Our installation guide will explain in details how to install SugarCRM community edition on an Ubuntu Linux machine. We use Ubuntu because it is very simple to install and maintain software on it.
To summarize, the steps required to get SugarCRM up and running on Ubuntu are:
- Get LAMP (Linux, Apache, MySQL and PHP) installed and running.
- Download source files of SugarCRM community edition.
- Complete setup of SugarCRM through the web-based installation wizard.
Installing LAMP
Before we can get into the SugarCRM installation and configuration steps, we need to install Apache, Mysql and PHP on the Ubuntu Linux machine. It is pretty straight foreword to get the LAMP stack up and running. To install Ubuntu, use this guide. To install the rest of the LAMP stack, follow the instructions here. If you are too lazy to read the instruction, you can use this command from your Ubunutu command line to get LAMP up and running:
#sudo tasksel install lamp-server
Downloading and Installing SugarCRM Community Edition
You can download the SugarCRM archive (.zip) file from here:SugarCRM Download Page
Just click the “Download now” button. Make sure you are downloading a file named ‘SugarCRM-x.x.x.zip’, where x.x.x is the version number, 5.2.0, for example.
Once you downloaded the SugarCRM zip file, you will need to extract it’s content using the unzip command, and then run the setup program. For a comprehensive guide on how to complete these steps, read the Sugar Community Edition Installation and Administration Guide.
*Note - you might not have the unzip command available on your Ubuntu machine. In that case, install it by running:
#sudo apt-get install zip
That’s it! You now have a fully functional, free to use, enterprise class CRM solution!
Our next posts will explain the first setup steps required to get your SugarCRM installation ready for use by your users. Stay tuned by registering to our RSS feed.
Mobile SugarCRM:BlackBerry,iPhone,Voice Recognition
There is no doubt that mobile is the next frontier of business management software in general, and CRM applications in particular. SugarCRM, the leading open source CRM solution, recently restated its commitment to mobile integration, with improved support for handheld device. 3rd party developers are also offering useful integration between mobile and Sugar.
SugarCRM - iPhone, BlackBerry integration
Apple’s iPhone is the hottest mobile device on the market, growing its market share from day to day. Initially, the iPhone was adopted by tech geeks, and was made popular because of unmatched Internet browsing experience for a mobile device and a successful application store. As popularity grew, the invasion of the iPhone into the enterprise, where the Blackberry device was the undisputed king, was inevitable. Business applications for the iPhone began to spring like mushrooms after the rain. Sugar, one of the most popular CRM solutions in the market, was not left behind.
One iPhone solution is Mobile Edge for SugarCRM, by iEnterprise. The solution (which is also available on Blackberries) allows you to import your Sugar contacts, tasks and appointments into your iPhone. But it’s not just a ‘read’ application - you can also create new SugarCRM objects, right out of your iPhone - new contacts, opportunities and tasks. As Sugar is targeted mainly at salespeople, who spend a lot of time on the road, in trains and in airports, this mobile applications can improve productivity and help in better decision making.
The MobileEdge for SugarCRM on Blackberry is available for 25$ a month.
I.V.R For SugarCRM
Writing software that will identify human speech and ‘translate’ it to text is extremely useful, but just as difficult. One company offering voice recognition on demand services is Angel.com - an I.V.R (Interactive Voice Response) solution provider. With their SugarCRM connector, users can access, update and manage Sugar accounts simply by using voice commands. Another cool feature is the ability to send emails from Sugar - dial a number from your mobile, speak out the email message text, and send it by using a voice command - no handheld device necessary, no struggling with miniature keyboards.
I would love to get a chance to check out Angel.com voice recognition engine in conjunction with SugarCRM. If this solution works properly, it’s truly an amazing productivity booster. From my experience with other voice recognition software, they are never bullet proof and might require some ‘training’ to gain true benefits from them.
-
RSS Feed
