<div dir="ltr">In similar line to some of the other suggestions:<div>1. A cache sounds like a must here.</div><div>2. Make the process which updates the database to also clear the cache to trigger a refresh.</div><div><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 17 November 2013 19:18, Erez D <span dir="ltr"><<a href="mailto:erez0001@gmail.com" target="_blank">erez0001@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div><div><div><div><div>hello<br><br></div>i have a web page that refreshes all the time to display things from a mysql database which is updated from time to time.<br></div>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.<br>
<br></div>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).<br><br>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.<br>
<br></div>does mysql support that ?<br></div>examples of doing that will be nice<br><br><br></div>thanks,<br></div>erez.<br></div>
<br>_______________________________________________<br>
Linux-il mailing list<br>
<a href="mailto:Linux-il@cs.huji.ac.il">Linux-il@cs.huji.ac.il</a><br>
<a href="http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il" target="_blank">http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">
<a href="http://www.linkedin.com/in/gliderflyer" target="_blank">
<span>
<img src="http://s4.licdn.com/scds/common/u/img/webpromo/btn_viewmy_160x25.png" alt="View my profile on LinkedIn" height="25" width="160">
</span></a></div>
</div>