Running SugarCRM on QNAP TS-119PII is slow. Therefore, I decide to separate PHP programs and MySQL database onto different computers. For small database, network transfer delay is okay to ignore.
Let’s take a look at the test now!
Processor, RAM, and Linux Difference
While QNAP TS-269L is based on Intel Atom D2701 running at 2.13GHz, QNAP TS-119PII is Marvell 88F6281 at 2.0GHz, Shuttle X50V2 is Intel Atom D510 at 1.66GHz, and Lenovo ThinkCentre Edge 72z is Intel Pentium G630 at 2.7GHz.
Both D2701 and D510 has 2 cores with 4 threads and 4 times the cache (1MB vs 256KB) compares to the single core 88F6281. G630 is 2 cores with 2 threads and 3MB Smart Cache.
D2701, D510, and G630 have 64-bit instruction set while 88F6281 is 32-bit. TS-269L and TS-119PII are running 32-bit QTS. TurnKey Linux in X50V2 and OpenSuSE 13.1 in Edge 72z are x64.
eAccelerator is included in QTS. XCache is in TurnKey Linux. Alternative PHP Cache is in OpenSuSE. All PHP accelerators may cache opcode to reduce interpret time.
Test Method
I connect NAS to computer directly. MySQL is configured for remote connections on QTS as in Using NAS as your Database Server. SugarCRM is download from SugarForge and is installed manually on Edge 72z as a client. All setup with build-in demo data.
About the environment, Apache is in prefork. memory_limit in php.ini has been increased from 128M to 256M. Unnecessary background process and programs are disabled on NAS.
TS-119PII is configured with following disk set.
TS-269L is configured with following disk sets.
According to my MTU test, I keep it as default 1500.
I measure load time for 1 and 5 contacts in a single login session with Firefox. The 5 contacts are loaded in different tabs.
If you are confused or interested in the relationship of LAMP, thread, multi-core processor, hyper-threading, please refer to How Multi-Core Processors Accelerate your LAMP Applications.
Performance
For reference, I also include SugarCRM performance test on TS-269L, TS-119PII, X50V2, and Edge 72z as Type: AP + DB in the table.
Analyze
Compared to running SugarCRM on TS-119PII, if you move the PHP programs to Edge 72z and leave MySQL on TS-119PII, you get 64% performance gain for retrieving 5 contacts. On the other hand, TS-269L is about 10% faster for the same situation in both disk sets.
Final Thoughts
For single user, TS-119PII is better to be used as a database server than running SugarCRM. TS-269L seems no big different between them.
When there are more concurrent users, the difference between TS-119PII and TS-269L should become more noticeable. Based on the hardware architecture of D2701, 4 concurrent user is the best scenario for TS-269L.
You may use memcached and follow the instruction in Enable Support for memcached section in Optimize LAMP for SugarCRM to improve performance.
Reference
- SugarCRM
- QNAP TS-119PII
- PHP
- MySQL
- QNAP TS-269L
- Intel Atom Processor D2700
- Marvell: Marvell 88F6282 SoC
- Marvell: Marvell 88F6281 SoC with Sheeva Technology
- Shuttle X50V2 Datasheet
- Intel: Intel Atom Processor D510
- Lenovo: ThinkCentre Edge 72z
- Intel: Intel Pentium Processor G630 (3M Cache, 2.70 GHz)
- Wiki: Thread (computing)
- Wiki: Smart Cache
- Wiki: Instruction set
- QNAP: QTS
- TurnKey Linux
- OpenSuSE: Portal: 13.1
- QNAP: App Center (QPKG)
- eAccelerator
- XCache
- PHP: Alternative PHP Cache
- Wiki: List of PHP accelerators
- Connect NAS to your Computer Directly
- Using NAS as your Database Server
- SugarForge
- Apache
- Apache: Apache MPM prefork
- PHP: PHP Manual: Appendices: php.ini directives: memory_limit
- PHP: PHP Manual: Appendices: php.ini directives
- AnandTech: Kingston SSDNow V+100 Review
- Trusted Review: OCZ Vertex 120GB SSD review
- Seagate Surveillance HDD
- Wiki: RAID 1
- Wiki: Session (computer science)
- Mozilla: Firefox
- Wiki: LAMP (software bundle)
- Wiki: Multi-core processor
- Wiki: Hyper-threading
- How Multi-Core Processors Accelerate your LAMP Applications
- memcached
- Optimize LAMP for SugarCRM
Amigo's Technical Notes 