webdevcody / wdc-saas-starter-kit

https://wdcstarterkit.com/
MIT License
867 stars 221 forks source link

feat: Add indexes to commonly queried fields #25

Open camwebby opened 3 weeks ago

camwebby commented 3 weeks ago

Resolves #16 Adding these indexes poses a trade off between write and read speed for tables where an index has been added which is why I have tried to be parsimonious to add only fields that are commonly used in application queries, and where I thought the table was more read, than write heavy. This should greatly improve scalability of any queries that use these fields.