Book Image

Phalcon Cookbook

By : Serghei Iakovlev, David Schissler
1 (2)
Book Image

Phalcon Cookbook

1 (2)
By: Serghei Iakovlev, David Schissler

Overview of this book

Phalcon is a high-performance PHP framework delivered as a PHP extension. This provides new opportunities for speed and application design, which until recently have been unrealized in the PHP ecosystem. Packed with simple learning exercises, technology prototypes, and real-world usable code, this book will guide you from the beginner and setup stage all the way to advanced usage. You will learn how to avoid niche pitfalls, how to use the command-line developer tools, how to integrate with new web standards, as well as how to set up and customize the MVC application structure. You will see how Phalcon can be used to quickly set up a single file web application as well as a complex multi-module application suitable for long-term projects. Some of the recipes focus on abstract concepts that are vital to get a deep comprehension of Phalcon and others are designed as a vehicle to deliver real-world usable classes and code snippets to solve advanced problems. You’ll start out with basic setup and application structure and then move onto the Phalcon MVC and routing implementation, the power of the ORM and Phalcon Query Language, and Phalcon’s own Volt templating system. Finally, you will move on to caching, security, and optimization.
Table of Contents (17 chapters)
Phalcon Cookbook
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Index

Optimizing PHQL queries


PHQL is by default one of the fastest ORM technologies available in PHP but even so there are still things that need to be understood if one wishes to achieve top efficiency. In this recipe, we will first start with the least efficient approach and then we will progress to two increasingly faster and more memory-efficient approaches. The first stage of this recipe will involve generating database records and their linked records. Once we have created these records then we can perform the three tests to see how they measure up.

Getting ready

This recipe uses the Phalcon Developer Tools, which we will use to set up a project skeleton.

We will need a database connection for this recipe.

How to do it…

Follow these steps to complete this recipe:

  1. We need to have an application skeleton for experimentation. If you already have such an application, you can skip this step. Create a project skeleton using the cli template:

    phalcon project optimize_phql cli
  2. Create the database, optimize_phql...