What I have is a button, and whenever a user clicks it a MySQL database field gets updated and the value is displayed to the user. I'm polling every 800 milliseconds and it's very laggy/glitchy. Sometimes when clicking the button it doesn't register it. And I actually need to be polling quite a bit more frequent than every 800 milliseconds.

This is also with just 1 user on the website at a time... When in the end there is going to be many at once.

A reliable 800 millisecond poll across the internet is a big ask.

On a private LAN, with a single IP packet in each direction, optimised dedicated server-farm for load sharing, optimised sql, a compiled servlet rather than an interpreted script, and with all client computers in some sort of non-interruptive "games mode" then you might be in with a chance.

Departure from any of these conditions is likely to add delay and variability of delay.

Airshow

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.