Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Activity DB Design Discussion


Ron Rennick
Participant

@wpmuguru

@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.

Skip to toolbar