On Sun, Nov 17, 2013 at 10:36 AM, ik <ido...@gmail.com> wrote: > Hi, I think you tackle it wrong. > > If there is no need for accessing the database all the time, why not cache > the result in tools such as Memcached or Redis ? > then i will still need to poll Memcached or Redis. this may speedup things, but it is still polling, which i try to avoid
> If they are different clients (as in agents), then there are other tools > at your disposal, such as Varnish, that create cached version for the web. > still neab client need to poll the server > > Secondly, the MySQL/MariaDB triggers really basics if you compare them to > PG and Fb (true open source solutions), not to mention non open source > databases such as SQL Server and Oracle. > > Third, try to see how you can optimize the page. If there is no need for > constant data reading, why does it constantly refresh itself ? > i do not refresh the whole page, i use ajax. i need a repsonse time from db change, to display on browser of 5 seconds, however the db may not change in days, and then can change every second... if we talk about polling, i need to poll every 5 seconds, but if there is no db change, then this is in vain i want to work event driven, and not polling, so i thought mysql has a builtin machanism for this. if it doesn't i will need to warp it up in some other code - i was trying to avoid that. thanks, erez. > > Ido > > > On Sun, Nov 17, 2013 at 10:18 AM, Erez D <erez0...@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@cs.huji.ac.il >> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il >> >> >
_______________________________________________ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il