Chapter 8. Performance Considerations
DreamFactory is a PHP-based application, and while we work hard to optimize the code at every opportunity, performance is going to largely be dictated by decisions made at the infrastructure level. Fortunately, these decisions are not so much dictated by budget as by sound technology and hosting choices. While your DreamFactory environment will undoubtedly be more performant on for instance an AWS t2.large than on a $15 Digital Ocean Droplet, the chasm between the two can be dramatically reduced when care is taken to properly configure and tune the environment. In this chapter we'll provide some general performance benchmarks, and then provide guidance how to ensure your DreamFactory instance is running at peak capacity.
The following table presents DreamFactory’s average response time in association with hosting the platform on various popular hosting solutions. In each case the hosting environments were unmodified, and not optimized in any fashion. It is however important to note all are running PHP 7.2, NGINX, and PHP-FPM.
|Environment||Load and API Type||Average Response Time|
|$15 Digital Ocean Droplet||10 MySQL API requests/second (10 records)||2524 ms|
|$15 Digital Ocean Droplet||10 MySQL API requests/second with caching enabled (10 records)||101 ms (96% improvement)|
|$15 Digital Ocean Droplet||10 MySQL API requests/second with caching enabled (100 records)||145ms|
|AWS t2.large||50 MySQL API requests/second (100 records)||83 ms|
|AWS t2.large||50 MySQL API requests/second with caching enabled (100 records)||72 ms (13.3% improvement)|
|AWS t2.large||100 MySQL API requests/second (100 records)||85 ms|
|AWS t2.large||100 MySQL API requests/second with caching enabled (100 records)||73 ms (14.2% improvement)|
|AWS t2.large||10 S3 API JPEG file requests/second||198 ms|
|AWS t2.large||10 MySQL API requests/second (1,000 records)||281 ms|
|AWS t2.large||10 MySQL API requests/second with caching enabled (1,000 records)||264 ms (7.2% improvement)|
These load tests were carried out using the third-party load testing service Loader.io..
The clearest takeaway here is that enabling database caching can have a tremendous impact on performance in the event you’re running DreamFactory on a low-powered server. In more robust server environments the impact isn’t as stark, however all the same enabling caching on the AWS t2.large produced on average a 11.6% performance improvement for the scenarios cited above. So what else can you do to improve performance?
Optimizing DreamFactory's Database APIs
Ensuring the DreamFactory-generated database APIs are running at peak performance is accomplished by ensuring your database is properly configured, has been allocated appropriate hardware and network resources, and turning on DreamFactory's database caching feature. In this section we'll talk more about all of these tasks.
Index the Database
For database-backed APIs, there is no more impactful task one could take than properly indexing the database. Database indexing is what allows your database engine to quickly identify which rows match conditions defined by a
where clause. Refer to the following resources for both general and database-specific indexing information:
Database API Caching
Enable database API caching whenever practical, as it will undoubtedly improve performance.
DreamFactory instances may be load balanced, and can be configured to share the system database, cache details, and other information necessary to operate in a distributed environment. Below are some links that may help you configure a load balancer with some of the most common cloud providers.
DreamFactory enables file-based caching by default, however you may opt to configure one of the other supported caching solutions, such as Redis. Please see these links to see connection tutorials:
Load Balancing Your DreamFactory Environment
You can use a load balancer to distribute API requests among multiple servers. A load balancer can also perform health checks and remove an unhealthy server from the pool automatically. Most large server architectures include load balancers at several points throughout the infrastructure. You can cluster load balancers to avoid a single point of failure. DreamFactory is specifically designed to work with load balancers and all of the various scheduling algorithms. A REST API request can be sent to any one of the web servers at any time and handled in a stateless manner.
Compiling the DreamFactory Code with OPcache
You can achieve particularly high performance by compiling your DreamFactory application code using OPcache. The following
- "NGINX Cookbook: Advanced Recipes for High Performance Load Balancing": This 175 page guide offers deep insights into and concrete solutions regarding NGINX scaling.
- Amazon EC2 cost calculator: This calculator can help you navigate AWS' notoriously opaque EC2 instance pricing model.
These are just a few tips intended to help you ensure your DreamFactory environment is running at peak capacity! If you have other ideas, please send them to code AT dreamfactory.com!