On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari wrote: > > What were the main benefits that you noticed straight away before > adapting your code to use the new features that MySQL 4 offers?
Replication is faster in 4.0. That's a big win for us, as we use replication pretty heavily. > Does the query cache make a big difference? Do you have any > benchmarks, even off your head? The query cache helps a lot. I ran some stats a while back. We have some queries that are as optimized as they can get. Accessing this page: http://biz.yahoo.com/n/y/yhoo.html uses the quey to fetch headlines. Without the query cache, that query can take anywhere from 50ms to 200ms to return (depends on the specific ticker and a few other factors). With the query cache, it returns in 4ms-6ms when the data is cached. For frequently accessed tickers, it makes a big difference. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 866,323,874 queries (388/sec. avg) --------------------------------------------------------------------- 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
