I've got a quite a lot of columns on the
users table and I have been cleaning it up recently. Now since I'm searching over the
users I figured it would improve performance if I separated verification columns from user. I'm talking about these kind of columns :
verified_telephone_number verified_telephone_by_id verified_photo_by_id verified_photo_source verified_photo verified_photo_at video_call_requested skip_video
So I was thinking to create
verifications table with each user having one verification and verification having these above attributes and some more.
Is there a downside to this approach? I mean for one, in terms of count, there will be
verifications rows =
users rows(count). Instead of having these extra columns.