No, to be honest 35 is nothing. You should not see any problems scaling this into the hundreds/thousands if optimized right, it does depend on many factors.
Where is the post meta being used, are you sure it’s all being used?
Are you using a lot of unique keys? You can check this by doing get_post_custom_keys
, the lower the better.
Are you outputting all post meta in one shot using get_post_custom
instead of getting each field via get_post_meta
?
You should always turn on debugging with define('SAVEQUERIES', true);
and see how many hits to the DB your doing and how long each one is taking.
Related Posts:
- How to solve slow WordPress site caused by attachment_metadata
- Why WordPress choose data serialization over json_encode?
- WordPress database scalability from the code perspective
- Dealing with Many Meta Values, 30+
- What is the most secure way to store post meta data in WP?
- Performance tips for a large user base [closed]
- WP_Options ID high
- How to delete outdated, wrongly sized images in _wp_attachment_metadata?
- WordPress for a very large website
- Meta query interfering with orderby relevance
- WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
- Improve or optimize a very slow query
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- Efficiency on displaying random authors based on large database
- Delete all post meta except featured image
- Relationship between performance and database size
- Database slowdown after update to 3.4.1
- wp_redirection_404 table has grown to 7GB
- Is it possible to store visitors IPs in wp_postmeta table?
- Multiple postmeta with same name for one post in wp_postmeta table
- Delete all post meta except featured image Using SQL
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- delete post meta from db, even if does not exist?
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- Storing data for a wordpress plugin
- Where does the actual data stored by add_post_meta
- Multiple wp_options tables to share content across installs
- Structure of postmeta meta_value for woocommerce product download
- Routine to convert custom post meta from old to new value
- Improve performance by removing unnecessary database queries
- fastest replacement DB
- How to prevent/delay MySQL connections when an object cache is used?
- Does auto_load to ‘no’ in wp_options improve performance
- Saving zero as meta value
- Uknown meta entries in wp_postmeta
- How to combine multiple wp_insert_post into one in order to gain better performance
- Does post_meta data need to be unserialzed?
- Link image with data from the wpdb
- Optimizing function that automatically creates internal links based on post title string
- Custom Post Type not showing anything added by code anymore?
- Compare User meta_value with Product meta_value
- How to save EXIF metadata in WordPress database?
- Is there anyway to split posts to different databases?
- _wp_attachment_metadata is not being added to database when PDF files uploaded
- Job and Employee Performance Tracking with Product Safety
- “BS_” rows in postmeta table
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- Migrating meta_key and meta_value from old theme to new one
- Get all top categories, then only 3 posts for each
- Best way to store 1 billion+ posts?
- Optimize WP site for millions of posts
- update_post_meta performance in a loop woocommerce
- update_post_meta performance in a loop woocommerce
- Database structure for thousands of posts
- Counting user’s comments – efficient way?
- Performance bug – slow DB query
- How much post meta data is too much?
- Mysql Queries per Visit – Crazy High
- How do i get value from wp_postmeta?
- Recommended Post Structure for DB Storage
- SQL query : Select a thumbnail for a media
- What effect can a large wp_post table have on overall site performance?
- wp_update_post function exclude specific field
- What is an ORM, how does it work, and how should I use one? [closed]
- What is the difference between an ORM and an ODM?
- What is this JavaScript “require”?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- What is this JavaScript “require”?
- What is “Advanced” SQL?
- What’s the difference between identifying and non-identifying relationships?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- What are the differences between B trees and B+ trees?
- MySQL SELECT increment counter
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Example of a strong and weak entity types
- Oracle SQL query for Date format
- phpMyAdmin – Error > Incorrect format parameter?
- Strange Characters in database text: Ã, Ã, ¢, â‚ €,
- Difference between partition key, composite key and clustering key in Cassandra?
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Database vs File system storage
- Can I have multiple primary keys in a single table?
- Exclude Statement in SQL
- How do you query for “is not null” in Mongo?
- What is a file based database?
- Is it fine to have foreign key as primary key?
- Storing Images in DB – Yea or Nay?
- Using wpdb to connect to a separate database
- how to Optimize WordPress database for 10 million post? [duplicate]
- MySQL Database User: Which Privileges are needed?
- Why is my database import losing text widget data?
- Database synchronization between dev/staging and production
- Keeping WP database synced across multiple developers using git
- Post meta vs separate database tables