Compare Storage Types
In most cases, you don’t really need to think about the storage type you choose when creating a Pod. But if you’re curious as to what the differences are, this comparison is for you. We’re currently working on re-testing the stats comparisons below to the latest version of Pods 2.0
Availability
Content Type
|
Meta
|
Table
|
---|---|---|
Post Types | ||
Taxonomies | ||
Media | ||
Users | ||
Comments | ||
Advanced Content Types |
Database Impacts (1.x)
Database Impact
|
Meta
|
Table
|
---|---|---|
JOINs per extra field in Query | ||
Average Index Length per field | 31.69 bytes | 0.7168 bytes |
Average Data Length per field | 72.9 bytes | 32.4 bytes |
MySQL rows per item (Y = # of fields) | 1 x Y | 1 |
MySQL ALTER TABLE when adding / removing fields | ||
DB definitions per field No CAST() needed |
Database Testing (1.x)
Database Test
|
Meta
|
Table
|
---|---|---|
Examples assume 50k items with 20 custom fields | ||
JOINs for Query filtering by 20 custom fields | 20 | 1 |
Index Length | 31,690,752 bytes | 716,800 bytes |
Data Length | 72,800,000 bytes | 32,400,000 bytes |
MySQL rows | 1,000,000 | 50,000 |