Bennett Haselton writes: > I don't know if MySQL handles this, but if a database system knows about a > particular type of query that is executed very often (either you enter this > query manually as a "common query", or the database detects it), can you > instruct the DBMS to cache the results of the query -- and to examine all > updates to the data, so if an update causes the query results to change, > the cached results will be changed accordingly? Is there a name for this > kind of practice, some word that I could look up in the index of a book > about databases?
[skip] > -Bennett > > [EMAIL PROTECTED] http://www.peacefire.org > (425) 649 9024 Hi! Query cacheing is right now in the works in 4.0. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php