O'Reilly logo

CMS Made Simple Development Cookbook by Samuel Goldstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a database index when creating a table

When your module accesses the database, it is usually either to store or to retrieve data. You have defined a schema for your data, and stored it using relational algebra in one or more tables. For most CMS-related applications, you do a lot more querying from the database than you do inserting or changing data; for example, you may add a News article once, but it is displayed every time someone hits the front page of your website.

Relational database management systems have been refined over decades to manage tabular data with very high performance. In the simplest case, each row in a database table is referenced by its key (for example, "employe_id"), and the database automatically creates an index ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required