It'd be nice to consolidate and lighten the load on the EL system. However, Schema:Edit isn't running on 100% of edits; is this going to be a problem?
|Stalled||None||T118063 Reconsider the schema of the Edit event log|
|Open||None||T123958 Consider scrapping Schema:PageContentSaveComplete and Schema:NewEditorEdit, given we have Schema:Edit|
Actually we do not want to have large -catch it all schemas bur rather distinct schemas per event. Thus having an schema for NewEditorEdit makes a lot of sense. I would go the opposite way and say that Edit schema should be split in more meaningful sections.
I've been thinking about it, and I'm not actually sure it makes sense to normalize the schema. Even if we do that, I don't see any reason to keep NewEditorEdit. I'll keep this open while I think about it.
Benefits of denormalizing:
- Querying will be easier in general
- Storage space will be substantially reduced
- Performance for specialized queries (e.g. how many events per EditingSession?) will see substantial performance increases
- Less data is sent from the browser client per event.
Performance for queries that join and filter across tables will not suffer substantially assuming we do appropriate indexing. I'm happy to help with that.