Database Scalability & Performance with Large Number of Listings

General HivePress
1

Hi team,

We’re planning to scale our HivePress-based site to thousands of listings and had a few concerns:

  1. Since all listing data and custom fields are stored in standard WP tables (wp_posts, wp_postmeta), how is performance optimized to prevent database bloat and slow loading as the data grows?
  2. Is there a way (or best practice) to use separate custom tables for listings and attributes to improve speed?
  3. Have other users experienced slowdowns with large-scale usage? Any suggestions to avoid that?

Would appreciate insights on how HivePress is structured to handle large volumes and any advice for scaling smoothly.

Thanks!