perf: Make the `UNIQUE CONSTRAINT` in `parties` lighter

Tietokilta / laskugeneraattori

MIT License

1 stars 2 forks source link

perf: Make the `UNIQUE CONSTRAINT` in `parties` lighter #8

Closed lajp closed 8 months ago

lajp commented 10 months ago

This could be achieved by splitting the parties table into multiple smaller tables, for example splitting people from addresses and then applying UNIQUE CONSTRAINTs for those. The smaller tables would be referenced from the invoices table.