WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


Hello, I am making coupon website and I need an advise. So, the structure at the moment is like this:

  1. Coupons ( posts )

  2. Categories of coupons ( categories )

  3. Shops ( tags )

In the near future my database will consist of approximately ~5000 shops ( tags ) and ~20000 coupons ( posts ) and also ~10000 of categories of coupons ( cats ). I will also add deals to website soon, so this might be also taken into consideration.

The question:

What is the best way to organize such website, so it will work flawlessly after such huge amount of entries in database? Should I use Custom Post Types for any of my taxonomies?
Thank you

share|improve this question
As coupons will be related to a shop, how about using Shops as categories or another taxonomy? Use tags for its generic purposes or for coupon categories. However, the numbers you've mentioned will not be matter to worry for the database. – HungryCoder Jun 19 '12 at 8:33
Take a look at this: wordpress.stackexchange.com/q/55749/12615 – brasofilo Jun 19 '12 at 19:07
up vote 0 down vote accepted

Custom Post Types are more convinient and easy to implement, so I suggest you use them. Also the Posts will be ready to make a blog section in the future.

About optimizing.

  1. Use some caching plugin, there are lots of them in Wordpress Plugin Directory.

  2. Turn off the revisions to save database size: add define ('WP_POST_REVISIONS', 0); into wp-config.php

  3. And try to use as less plugins as possible. Only what you really need.

share|improve this answer
Thank you for advice about turning off revisions. That might be helpful. – Godforever Jun 19 '12 at 12:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.