Ticket #73 (assigned defect)

Opened 3 years ago

Last modified 2 years ago

Pubbot chat module

Reported by: Maverick Owned by: Maverick
Priority: normal Component: Bots - PubHub/PubBot
Version: Latest version from repository Severity: blocking
Keywords: tw chat pubbotchat pubhubchat Cc:

Description (last modified by Maverick) (diff)

The chat module of the pubhub is still too resource-intensive for the mysql server.
On each chat line it receives it does a INSERT, SELECT and DELETE. With about 10 arenas being monitored this hogs the mysql server pretty much.

Flibb has given a good recommendation to use prepared statements but unfortunately TWCore doesn't support those.

So instead I'm going into a different road: Pubhubchat caches the chat lines and has a socket running. The PHP front-end, tw.org, opens a socket to the pubhubchat and requests the chat lines it needs every 10 seconds per user.

This approach totally skips the mysql server which is the reason why I'm doing this.

Attachments

Change History

Changed 3 years ago by Maverick

  • description modified (diff)

Changed 3 years ago by Maverick

  • status changed from new to assigned

Changed 2 years ago by milosh

  • component changed from Bots - Other to Bots - PubHub/PubBot

Add/Change #73 (Pubbot chat module)

Author


E-mail address and user name can be saved in the Preferences.


Action
as assigned
 
Note: See TracTickets for help on using tickets.