collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18366
  • stats Total Topics: 2501
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Persistant DB connections  (Read 3821 times)

0 Members and 2 Guests are viewing this topic.

Offline kardsen

  • BeBot Apprentice
  • ***
  • Posts: 81
  • Karma: +0/-0
Persistant DB connections
« 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

Offline Noer

  • BeBot Apprentice
  • ***
  • Posts: 107
  • Karma: +0/-0
Re: Persistant DB connections
« Reply #1 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.

Offline kardsen

  • BeBot Apprentice
  • ***
  • Posts: 81
  • Karma: +0/-0
Re: Persistant DB connections
« Reply #2 on: July 15, 2008, 07:57:04 pm »
Which version should be be using at this point?
r48     ?

Offline Noer

  • BeBot Apprentice
  • ***
  • Posts: 107
  • Karma: +0/-0
Re: Persistant DB connections
« Reply #3 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.

Offline kardsen

  • BeBot Apprentice
  • ***
  • Posts: 81
  • Karma: +0/-0
Re: Persistant DB connections
« Reply #4 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

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm ]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am ]

* Who's Online
  • Dot Guests: 296
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal