The current application does not have support for that, If I go for that, it will require a lot of effort from the team which Is not possible right now.
Thank you everyone for giving your valuable responses, I am glad that everyone understands my concern. I got some good ideas about the database design that I am following after going through some stress testing I will implement the same.