Title: 200  Database Queries!
Last modified: August 19, 2016

---

# 200 Database Queries!

 *  [Michelle Langston](https://wordpress.org/support/users/chellycat/)
 * (@chellycat)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/200-database-queries/)
 * I’m building one of those newspaper/magazine style themes and was very excited
   about the options page. I have many options that give the user fine-grained control
   over their site and allows them to create a unique look.
 * However, in my excitement I realized that I overlooked something. Each of those
   options is a separate database query. I loaded my front page and it has 214 queries
   alone when everything is set to display! It loads in about 0.8 seconds. When 
   stored in cache it loads in about 0.6-0.7 seconds. On pingdom.com, it loads in
   about 4 seconds.
 * When I install W3 Total Cache the number of queries is reduced to 202. The theme
   can be scaled back and users don’t need to display as many news sections or widgets,
   but I’m concerned that I have too many queries. When does the number of queries
   become too much?
 * Is there a way to write a theme options page that minimizes the number of queries,
   even if you want to provide a lot of options? What do other creators of magazine
   themes do?

Viewing 1 replies (of 1 total)

 *  Thread Starter [Michelle Langston](https://wordpress.org/support/users/chellycat/)
 * (@chellycat)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/200-database-queries/#post-1418580)
 * Anyone have any suggestions? This is really a big issue! I would appreciate some
   insight greatly. Thanks. 🙂

Viewing 1 replies (of 1 total)

The topic ‘200 Database Queries!’ is closed to new replies.

## Tags

 * [queries](https://wordpress.org/support/topic-tag/queries/)

 * 1 reply
 * 1 participant
 * Last reply from: [Michelle Langston](https://wordpress.org/support/users/chellycat/)
 * Last activity: [16 years, 3 months ago](https://wordpress.org/support/topic/200-database-queries/#post-1418580)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics