Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

How we would create XML without any load on MYSQL?

How we would create XML without any load on MYSQL?

Problem

I have a Mysql database with an activity table whose rows are text statements(activities). My challenge is to Push the latest activity into the ticker(An area where all my latest activity display) as soon as it gets inserted into the table . I can achieve this pinging the table every N seconds , but this consume a lots of memory resourses and Server. So XML is the best way , but problem with how to create a XML file without Any load of MYSQL? Please suggest me how to achieve this . Thanks in advance !!!

Problem courtesy of: Vikas Sharma

Solution

Websockets are designed to respond to PUSH requests (server to client) problematics, avoiding these costly "refresh every x seconds" operations.

Apparently HTML5 provides new tools to handle websockets, maybe you wish to have a look at them?

refer to: http://www.html5rocks.com/en/tutorials/websockets/basics/

Solution courtesy of: Sebas

Discussion

View additional discussion.



This post first appeared on Node.js Recipes, please read the originial post: here

Share the post

How we would create XML without any load on MYSQL?

×

Subscribe to Node.js Recipes

Get updates delivered right to your inbox!

Thank you for your subscription

×