Flat Table Entity Data

Component ID

2702923

Component name

Flat Table Entity Data

Component type

module

Maintenance status

Development status

Component security advisory coverage

not-covered

Downloads

212

Component created

Component changed

Component body

This module stores each bundles of entity data in single row. Example, if a content type "page" having 10 different fields, it holds the whole node data in single node. It wont replace the existing field storage. But this module halps to reduce the number of joins when viewing node. This will be useful for heavy read only sites. I developed this to increase the performance for a drupal site which powers dozen mobile app. This reduce the latency.

What it do :
Say if you have Entity "node" and content type "school" with following fields, School name, School code, Address field, Logo, Contact person. This module create a table "fted_node_school" and create following fields : eid, school_name, school_code, address_1, Address_2, city, address_XX, address_YY, logo_fid, logo_height, Logo_URL, logo_width, contact_person

Whenever you add a node, it create a row in this table, (and update and delete), so if your site is read heavy (example mobile apps via JSON API) and want reduce the number of joins, Or heave View dozens of fields, this module helps to increase the performance.

Benchmark :

It took, 150mb and 45 seconds when i used views to join 4 content types with aggregate views. For same output, with this module, it just took 25mb memory and 2 seconds.

Caution : This wont check any access permission,

Work under progress, Thoughts and feedbacks are welcome. Documents on the way.