Split content into its own model
Based on some performance testing, I'm seeing a 40% reduction in main inbox query speed locally when
Based on some performance testing, I'm seeing a 40% reduction in main inbox query speed locally when content is not included in the results (avg of 2.13s vs 1.17s).
If we move content into its own, model, we won't need to fetch content unless:
- we are displaying or editing socra content
- we are displaying timeline items
This should great performance boost. Additionally, we won't need to lock the socras table any time we're changing content. **Title: Split Content into Its Own Model**
On November 18, 2024, Mike Morton conducted performance testing revealing a significant 40% reduction in main inbox query speed when content is excluded from results (averaging 2.13s vs. 1.17s). To enhance database efficiency, the decision was made to split content into its own model. This change means that content will only be fetched when displaying or editing socra content or when showing timeline items.
This model optimization is expected to provide a substantial performance boost and eliminate the need to lock the socras table during content changes. This strategic move aims to optimize performance testing results and streamline content management, ultimately enhancing overall system efficiency.By Mike Morton