Intro:
Hello, I am making coupon website and I need an advise. So, the structure at the moment is like this:
-
Coupons ( posts )
-
Categories of coupons ( categories )
-
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
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.
Use some caching plugin, there are lots of them in WordPress Plugin Directory.
Turn off the revisions to save database size: add
define ('WP_POST_REVISIONS', 0);into wp-config.phpAnd try to use as less plugins as possible. Only what you really need.