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
