Organize WordPress site, so it can maintain with huge database

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.

Related Posts:

  1. How to set individual capabilities on a taxonomy? Or how to re-register an existing taxonomy?
  2. How to organise this data within WordPress
  3. Changing an item in drop down after 5 latest posts per taxonomy
  4. Database to page routing API?
  5. Custom post taxonomies as tax_query terms?
  6. Get related posts of child term of custom post type
  7. Limit amount of posts made within a custom taxonomy
  8. Issue on Creating Custom Tax Term Dynamically From Another CPT Meta-box On Publish
  9. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  10. read_post meta capability for anonymous users
  11. WooCommerce Customer Role Delete Custom Post Type
  12. list taxonomies from a custom post type
  13. Display a grid of taxonomy terms at root taxonomy page
  14. delete_published_posts does not work
  15. Permit users with author role to edit a custom post type
  16. Able to edit custom post, but unable to create new custom post when within submenu. What capability is missing?
  17. Show child custom post types list inside single parent custom post type
  18. limit value taxonomy based on previous taxonomy value wordpress
  19. How to change wp prefix for custom post type only?
  20. Several post types on WP Query by tag and taxonomy
  21. Using meta_query and tax_query at the same time
  22. How do I display the taxonomy for a custom post type in an array
  23. Set a CPT slug as a base name for all the taxonomies
  24. How to conditionally redirect to the post from a taxonomy page?
  25. How do I check if the user is on a taxonomy term parent, child or grandchild page?
  26. How do I display the grand child items of a taxonomy term?
  27. Taxonomies relations
  28. Is it better to use WordPress Custom Post Types or Taxonomies?
  29. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  30. Full Custom Post Type List Organised by two Taxonomies
  31. Add update or delete database records using custom post type
  32. WordPress Doesn’t Generate Taxonomy Archive
  33. How to import a custom MySQL DB table into a WordPress custom post type
  34. Disable user from updating certain posts
  35. Suggested Post and Taxonomy structure
  36. “Submit for review” for updates on existing posts
  37. Access to CPT but not to ‘post’ post type
  38. Allow add new post access to custom post but not wp post for some role
  39. Custom post with more than one custom taxonomy
  40. Get the taxonomy of a post hierarchically
  41. How to restrict author to only access one custom post type ?
  42. Cannot Create new Post within Custom Post Type
  43. Adding custom taxonomy in same menu place with two custom post types
  44. How to make custom taxonomy into drop down select in a custom metabox
  45. Multiple pages for posts?
  46. Allow user to only access custom post type
  47. Display latest x posts from all categories in Custom Post Type/Taxonomy
  48. Custom post type submenu capabilities – custom plugin
  49. How to get list of taxonomy slugs ordered parents>childs?
  50. WP_Query orderby and tax_query
  51. re-register custom post type with custom capabilities
  52. Conditional statement for if archive page has posts which contain certain taxonomies/categories/tags, show those terms
  53. How do I share categories across multiple post types?
  54. How to organize hierarchical structure in custom post type with taxonomy (like with categories)
  55. Multiple tag cloud filtering
  56. Get url.com/post_type/taxonomy/term work!
  57. How to display products name in a non-alphabetical order, in a custom field (taxonomy)?
  58. Importing Data from a Non-WordPress database, into WP
  59. Taxonomy in URL
  60. Review site custom post type structure
  61. Filter get_cat_id for Custom Post Type
  62. Save custom post type to external database
  63. Different Category system needed for the Custom Post Type
  64. Custom Post Type Category Link
  65. Custom Post type category pages template and loop
  66. Output terms for custom post types
  67. Linking from CPT page to taxonomy.php
  68. Page not found for custom post type UI plugin and taxonomy
  69. Show data from one Custom Post Type in another Custom Post Type
  70. Unable to link categories to custom post type using standard function
  71. How to Set Taxonomy Object Description?
  72. Categories and tags for custom post types
  73. Custom select query for taxonomies that have posts categorized in another taxonomy
  74. Enable taxonomies by post type in an array of CPTs
  75. How to assign tag to custom post type in wordpress?
  76. Custom Taxonomy Is Being Pulled into a Page, But It Doesn’t Have A Hyperlink
  77. WordPress custom post type capabilities issue
  78. Querying two taxonomies with tax_query not woking
  79. Rename a slug label
  80. Specifying meta field’s column type in Database using add_post_meta
  81. Custom Taxonomy Category link
  82. Get Post Terms of Current Post (selected taxonomy term) – How to get only the taxonomy value and not “Array ( [0] => taxonomy term )” in the frontend?
  83. Replace dynamically content in a custom database table when a custom post is created
  84. How to get all Custom Post Type Filtered by one Specific Taxonomy Term
  85. Hide specific taxonomies from a taxonomy list using ‘get_object_taxonomies’
  86. How does the ‘the_post_navigation()’ work for CPT’s?
  87. Running a song lyrics site on WordPress
  88. Custom post type – list posts based on meta_key and display them divided by CPT taxonomy category
  89. Save and user submitted data from a form and display them in the wp backend
  90. Custom taxonomy (categories) on custom post type return no results
  91. Filter second dropdown (tax) based on first dropdown (cpt)
  92. Dump custom post type database
  93. Variable not working in WP_Query
  94. Hide meta box for everything BUT a certain custom post type
  95. Archive-posttype.php isn’t loaded
  96. Should I use custom taxonomies or not?
  97. get_category_link() for custom post type does not include custom slug rewrite?
  98. Add tags to custom post type without menu link
  99. Conflict between Capabilities and Menu Visibility with Custom Post Types
  100. Designing a custom post type with a minimum number of meta fields
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)