mysql q

[Amos Shapira]

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 <erez0001 at gmail.com> 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
> Linux-il at cs.huji.ac.il
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>
>


-- 
 [image: View my profile on LinkedIn]
<http://www.linkedin.com/in/gliderflyer>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20131117/d9b3a147/attachment.html>