Rather than
SELECT a.pk, b.pk, c.pk, d.name
FROM a
JOIN b on b.pk = a.fk
JOIN c on c.pk = b.fk
JOIN d on d.pk = c.fk
I can do
SELECT a_pk, b_pk, c_pk, d_name
FROM view_a_b_c_d
I have a lot of this sort of thing through my code.
I've done a performance test, and the differences seem to be negligible, and I feel it would greatly tidy my codebase up and remove a lot of repetition.
But before I commit to that (as it'd be a big change with a lot of work and testing), I want to check that this IS a good thing to do. I didn't study computer science and have no formal DBA training. I'm also a sole dev working on my own closed-source product. So I don't get much input from the outside world, unless I strike out and ask for it.
Thank you - any opinions/experience appreciated.
JOINs
are optimized between MySQL (even the latest version) and recent versions of MariaDB. Or maybe you should remove themysql
tag to avoid this confusion. – Rick James Jan 9 at 22:15