Optimization TODOs

[thorrester]

We're currently refactoring and migrating db schemas for better performance and storage optimization. This list serves as a todo list as reminders.

• Find way to inject profile/entity UID into queue insert logic
• Custom logic migrations
  • sql
  • db logic
  • types
  • archive logic
  • py types
• PSI logic migrations
  • sql
  • db logic
  • types
  • archive logic
  • py types
• SPC logic migrations
  • sql
  • db logic
  • types
  • archive logic
  • py types
• LLM Record logic migrations
  • sql
  • db logic
  • types
  • archive logic
  • py types
• Tracing logic migrations
  • sql
  • db logic
  • types
  • py types