How to make "On Site Notification" plugin realtime?

Question

Hi,

is it possible to make "On Site Notification" plugin realtime? Something like: on every 5 sec. check for notifications: if there is any - show, if not - ignore. All that without reloading page!

I am beginner in PHP but I know a lot about ajax, parsing data, front-end, and I am quick learner :)

Comments

"I can see a lot of MySQL processes getting spawned -- nearly 50 and all of them are in sleep" => how many of them are spawned when you access the /activity section?

---

Almost nothing - at least nothing which goes to sleep. I just clicked the options of
http://www.q2apro.com/plugins/usersearch
plugin and it again hanged my site.

---

This confirms I won the bet: https://github.com/q2a/question2answer/issues/742 :)

---

Thank you Pupi. When you posted that then I didn't get what exactly you meant but now I do :)