Home Forums General Issues Flush/Clean deleted fields Reply To: Flush/Clean deleted fields

  • There is nothing that connects the field values saved with the field group. The only attachment is to the post, term or user that the metadata is for.

    This topic has come up many times [Forum Search]

    Actually, I don’t worry about the extra data because under normal operation it should not affect performance. Both the post_id and meta_name columns on the database tables are indexed. Since most queries are base on these columns the extra rows have little to no affect on query performance.

    Site performance is affected more by the number of queries performed or by performing “LIKE” queries on columns that are not indexed. Any queries based on the meta_value column would also be significantly affected, but this would still be the case without the extra rows. However, even here, when searching the meta_value you would likely still include the meta_key in your query, which is an indexed field, therefor an unused meta_key row would already be ignored by such a query and therefor that row would have no impact on the query.

    When talking about even a couple of dozen extra fields or more returned when doing a single query to get all of the metadata for a post, term or user the extra data returned has little affect on the individual query. You would need to have several hundred extra fields being returned to significantly impact the response time of a query.