Is there a limit to no. of connections. Will there be any issue(something like efficiency or anything else) if I create many connections like 1,000,000 or something.

Because you have control of the resources cpu/memory/disk you theoretically can achieve any number of connections you want to.