I may add, that it is always the same comment, so the query is exactly the same and SHOULD be cached.
-----Ursprungliche Nachricht----- Von: Christian Rabe [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 12. Januar 2003 01:41 An: [EMAIL PROTECTED] Betreff: Problem with query cache and comments Hi, I've been testing the query cache with mysql 4.0.8 and ran into a problem. the query select * from tablename where x=1; is cached correctly and generates nice hits when run more than once but if I add a comment like /* any comment */ select * from tablename where x=1; the query is cached, but there are no more hits I dont think this is intended ... Please reply or CC me directly, because I'm not on the list atm. Thanx and Regards, Christian Rabe --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
