Performance and Scalability
If you've got a need for speed, this group is for you.
Beginning Developers
This space is for newcomers, who wish to build a new plugin or to customize an existing one to their liking
Elgg Technical Support
Get support from other Elgg users
- Riadh Hamdi joined the group Elgg Technical Support
- Riadh Hamdi replied on the discussion topic Garbage Collector and removing data
- Riadh Hamdi added a new discussion topic Garbage Collector and removing data in the group Plugin Development
No, not all metastrings. Just the orphaned ones that are not used anymore.
Thank's Juho.
I try to read gc plugin code and i find the query used to delete metastring that don't have metadatas and annotations.
SELECT * FROM {$CONFIG->dbprefix}metastrings WHERE
(
(id NOT IN (SELECT name_id FROM {$CONFIG->dbprefix}metadata)) AND
(id NOT IN (SELECT value_id FROM {$CONFIG->dbprefix}metadata)) AND
(id NOT IN (SELECT name_id FROM {$CONFIG->dbprefix}annotations)) AND
(id NOT IN (SELECT value_id FROM {$CONFIG->dbprefix}annotations))
)
Never,It will delete only those which does not have metadatas and annotations as said by @ Riadh Hamdi
- Riadh Hamdi joined the group Plugin Development
- Riadh Hamdi replied on the discussion topic Relationship between three entities
- Riadh Hamdi added a new discussion topic Relationship between three entities in the group General Discussion
please don't start duplicate threads, you've already asked this exact question a few days ago. If you need to ask followup questions continue it in that thread.
The answer is to either use different relationship names
Sorry matt, I think to expand the topic.
But the answer does not answer exactly the question. The current model can't implement a relation beetwwen more than two entities, In design,ie an associative table with more primary key has a cardinality of 0 .. n
Thank you