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 |