The Field API generates a table storing data for each field. The structure of each record in the table includes two 128 character indexed fields -- one for the entity and one for the bundle to which the field is attached.
In the instance of making a boolean field, 300 bytes of data (256 of which are indexed) are used to store each boolean field containing a single bit of information.
This overhead is duplicated in the revisions table for the field. This results in wasted space and extra computer processing to find or save all that indexed information.
This storage overhead makes it problematic to use the Field API in applications that will store and access large quantities of data.
A New Field API could be much more efficient by saving simple two-byte integers that map to entity type and bundle information and using a mapping function to convert entity and bundle names to their appropriate integers. The New Field API could coexist with the old-school Field API, but provide leaner performance for new development.
Additionally, the names of entities and bundles would no longer be limited to 128 characters. They could be of arbitrary length.
Recent comments
Hi opentype I don't think there is a way to do this within the user interface and I'm not aware of any module that can help. There is a function that can move individual files (...
Moving from /files into subdirectories
Yes indeed. We are exploring a few other more costly options, but as we are a low-resource start-up, we could save a lot of money by integrating Backdrop, CiviCRM and Ubercart for our membership...
UberPOS for Backdrop?
Hello Chrys.., It looks like it was for Drupal 6, with a Dev release for D7... Never seen it before, but it looks like an interesting module... Do you have an immediate need...
UberPOS for Backdrop?