In similar line to some of the other suggestions: 1. A cache sounds like a must here. 2. Make the process which updates the database to also clear the cache to trigger a refresh.
On 17 November 2013 19:18, Erez D <[email protected]> wrote: > hello > > i have a web page that refreshes all the time to display things from a > mysql database which is updated from time to time. > however. this meens a lot of un-needed acesses to the database. and this > refresshing page may be openede by many browsers. causing a huge load on > the database. > > i know mysql supports triggers, but it seems this is only internal (i.e. > trigger may do a query, usually an "update" query, but this is not what i > need). > > I am looking for a way to leave the connection open with mysql, not > sending any queries, just waiting for mysql to notify me when a somthing > changes. > > does mysql support that ? > examples of doing that will be nice > > > thanks, > erez. > > _______________________________________________ > Linux-il mailing list > [email protected] > http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il > > -- [image: View my profile on LinkedIn] <http://www.linkedin.com/in/gliderflyer>
_______________________________________________ Linux-il mailing list [email protected] http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
