user_id in DB much larger than needed
|Reported by:||charleshooper||Owned by:||charleshooper|
|Component:||Optimization||Keywords:||has-patch 2nd-opinion dev-feedback|
Since the maximum # of users WordPress can support has been accepted as much much smaller than 2,147,483,647 the database schema should be modified to change all columns that reference a user ID to type INT.
Currently, all of these columns are type BIGINT, except for link_owner in wp_links for some reason. In addition, user IDs are type-casted to INTs in some places in the WordPress core, such as in get_userdata.
The attached patch changes all of the columns referencing user IDs to INTs and bumps wp_db_version.
Change History (12)
comment:2 @charleshooper — 8 years ago
- Owner changed from charleshooper to anonymous
- Status changed from assigned to new
comment:4 @charleshooper — 8 years ago
- Owner changed from anonymous to charleshooper
- Status changed from new to assigned