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 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 :)
- 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]