REPOST: one long lived connection or one connection per query

(REPOST: I never got my original post, or any answers, so I am reposting, assuming it was lost in the mail) Hi, I apologize in advance, I am sure this question has been asked dozens of times, but my searches came up empty. I am building an IRC based application "bot" (using libmysql) .. that will

one long lived connection or many short lived?

Hi, I apologize in advance, I am sure this question has been asked dozens of times, but my searches came up empty. I am building an IRC based application "bot" (using libmysql) .. that will take commands from users (!mybugs, !mybugs KEY !newbugs, etc), do SQL queries and of course dump formatte