Book Image

Drupal 7 Business Solutions

Book Image

Drupal 7 Business Solutions

Overview of this book

You can use the Drupal 7 content management system to build a small business website quickly. You may add blogs, images, maps, e-commerce, social application integration, and more to your site to connect with your customers and make more money from your business. Drupal 7 Business Solutions will give you hands-on practical tutorials on how to build a rich and dynamic website for your business quickly using one of the most popular tools in open source. You'll start by adding blogs and images to your website. Then you'll learn how to add a VIP section to your site so that you can give your logged in users special discounts and other VIP freebies. Next, you will learn to send your customers e-mail newsletters and show them a dynamic events calendar. The book will then teach you to add e-commerce to your site so you can sell your products online. You'll add YouTube videos and Google maps to help enhance your business site. You will then learn to incorporate feedback mechanisms for your customers. The book also explains how to maintain your site, upgrade it, and continue adding dynamic content to it.
Table of Contents (19 chapters)
Drupal 7 Business Solutions
Credits
About the Authors
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
Index

Optimizing your Drupal site and its database


If your website has a moderate to large number of visitors, you should tune your website for maximum performance. This will ensure that all your visitors have a positive experience, and are not frustrated by delays in loading pages or accessing the website.

We will discuss ways to optimize both the backend database, and the frontend of the website that displays the information to the visitor.

Optimizing the database tables

In this section we'll optimize our MySQL database tables using the DB Maintenance module.

Goal

Optimize the database where your site content is stored, to ensure the best possible performance.

Additional modules needed

DB Maintenance (http://drupal.org/project/db_maintenance)

Steps

When a database is used as frequently as the Drupal database is, it can become less optimized over time, because having a large number of records inserted and deleted from each table can result in the database having wasted space. All databases will allow...