I’m working on a database for an online game server. I’ve been looking into prepared statements and see that they are tied to a specific connection. Should I pool the statements instead of connections If that is all i plan to use? Or should I just use one connection per prepared statement?
You should create your connection once and re-use it for all prepared statements that will be used for all users. If you are going to gave a large number of users, you might want to create a few connections to use. But for now just try it with one(Singleton).