Title: adding columns to wp_posts?
Last modified: August 19, 2016

---

# adding columns to wp_posts?

 *  [vtblogmu](https://wordpress.org/support/users/vtblogmu/)
 * (@vtblogmu)
 * [16 years, 1 month ago](https://wordpress.org/support/topic/adding-columns-to-wp_posts/)
 * Is it safe to add columns to various tables in the wordpress database? Specifically
   wp_posts?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 1 month ago](https://wordpress.org/support/topic/adding-columns-to-wp_posts/#post-1441789)
 * Probably safe, but always a good idea to have a good database backup BEFORE doing
   any WordPress upgrade.
 * Also might consider using the wp_postmeta table for your application instead 
   of changing the database.
 *  [Alok Sharma](https://wordpress.org/support/users/aloksharma/)
 * (@aloksharma)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/adding-columns-to-wp_posts/#post-1442153)
 * I am working on a project in which I have to store up to 10 custom fields per
   post. So if I have around 1,000 posts, the post meta table will have around 10,000
   entires. In some instances, there may be only 3-4 custom fields per post but 
   when the post is being displayed, it will try to search all the 10 fields and
   then load only those which exist.
 * I wanted to know that which of the following works best:
    – Add new columns in
   wp_posts table & store custom fields in them – Use the existing wp_postmeta table
   for storing custom fields
 * In other words, what I need to know is that if all the custom fields are stored
   in the wp-posts table, won’t this increase the speed and efficiency as compared
   to storing custom fields in wp_postmeta table and then calling them when each
   post is loaded.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘adding columns to wp_posts?’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [php](https://wordpress.org/support/topic-tag/php/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [Alok Sharma](https://wordpress.org/support/users/aloksharma/)
 * Last activity: [15 years, 4 months ago](https://wordpress.org/support/topic/adding-columns-to-wp_posts/#post-1442153)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics