How long will a lip piercing hole be visible for?

As long as the body takes to minimize the piercing and close it, there is no magic solution that will make it close faster. It's just a matter of time.