Re: Activity DB Design Discussion
@Andy – A DB suggestion:
Make a register component api so that all components that are going to record in the SWA have to register. The registration process should occur at plugin activation and the component name strings are stored in a component table.
Once that is in place then you can eliminate the varchar component fields and replace with an int(11). This would reduce space in the table and improve lookup speed significantly when filtering.