Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

Intro:

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

1 Answer 1

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

 
discard

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.