BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => BeBot Hyborian support => Topic started by: kardsen on July 15, 2008, 07:02:28 pm

Title: Persistant DB connections
Post by: kardsen on July 15, 2008, 07:02:28 pm

Is there anyway to change the MYSQL connection string to a persistant connection?

My SQL database is remotely hosted as to the location of the bot... This way I can pull info from the SQL database to display it on the website... Such as who is in game, kos list, supplies list, ect.


The problem is there is a  pretty large delay in loading the bot, running queries.  ect.   Alot of this would be better if the connection was persistant rather than the connection ran each time the bot went to pull info

Title: Re: Persistant DB connections
Post by: Noer on July 15, 2008, 07:37:54 pm

This should be considerably better in the latest update we did with the 0.5.2 base code. Try upgrade and see if it is any better.

Title: Re: Persistant DB connections
Post by: kardsen on July 15, 2008, 07:57:04 pm

Which version should be be using at this point?
r48     ?

Title: Re: Persistant DB connections
Post by: Noer on July 15, 2008, 08:01:42 pm

Yep, I havn't made it available in a zip archive yet though. R46 is latest in a zip.

Title: Re: Persistant DB connections
Post by: kardsen on July 15, 2008, 08:09:02 pm

I'll update to R48.   Wasn't sure if that was a stable copy as you guys were making alot of changes over the last couple days :)

Thanks