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, !bug ID, etc), do
SQL queries and of course dump formatted results back to the channel.
Currently its setup to open a single DB connection at initialization
and use that connection over and over... would it be better or worse to
have it open/close a connection for each "command" in the way a web app
would?
Some things to keep in mind :)
- IRC server/services bot is half way across the US from the mySQL server (connection reliability?) - queries will likely be spaced out by hours or days (idle disconnect?) - when one person does a query, its almost assured that there will be 10 more within 10 seconds, its contagious or something :)
- I would *like* to do SSL (still studying how to do that), so that will most certainly increase the mysql_real_connect() time?
Does the client library maintain a "pool" of connections or something like that?
Thanks in advance, Tommy
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
