Field SQL Blob Storage

Component ID

2829978

Component name

Field SQL Blob Storage

Component type

module

Maintenance status

Development status

Component security advisory coverage

not-covered

Component created

Component changed

Component body

This module provides an alternative field storage backend. A table is created on a per-entity-type basis. All fields for each entity (well, those using our storage) are stored in one big serialized field.

This substantially reduces the number of database tables and database queries. It is an alternative to the caching approach offered by entitycache.

At present, the module uses json_encode()/json_decode() as this is purported to be faster for large data-sets. It is assumed that those who are using this module are doing so because of many many (hundreds, even thousands) of fields.

Trade-offs

Filtering and sorting (whether by EntityFieldQuery or by views) is not supported for obvious reasons.