Hello Elgg community members:
I am beginner in developing an Elgg plugin, I notice that all entities are stored in table called elgg_entities ("elgg_" prefix in my configuration file) in the database, the same thing for the relationships elgg_entity_relationships (table name in my database) and with time the number of entities and users increase , it may cause some performance problems ,is there a technique or another way to decrease the number of entities in elgg_entities table for example by distributing entities in more than one table ,for example table for each subtype of Object type ?
Thank you for your help.
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Jerome Bakker@jeabakker
Jerome Bakker - 0 likes
- Matt Beckett@Beck24
Matt Beckett - 0 likes
You must log in to post replies.I wouldn't worry too much. We have some communities with more than 1m rows in entities and the db is not the problem. Sure some optimizations needed to be made but not so much in the db structure but more in the programming in order to use better caching
It's a non-issue until you get to extremely large numbers. I'm managing a site that has almost 2 million groups, no issues.