Organize WordPress site, so it can maintain with huge database

Question

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

Answer 1

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.