Hi all, I seem to have a problem with query caching with MySQL 4.0.5a.
Check the two results below to see what I mean (the 2 queries were run one after another with no other changes.) I have tried it with and without and various combos of the following my.cnf settings - same result! query_cache_limit query_cache_size query_cache_type Anyone got any ideas why this query appears not to be caching? Cheers, Andrew Sql,query mysql> select * from ap023 where sb like '%39%' limit 900,5; +------+----+---------+-----------------+----------------+----+------------+ ----+----+----+---------+--------+--------+ | orgn | bn | sb | bd | tn | dr | pt | dl | dd | cn | pc | xcoord | ycoord | +------+----+---------+-----------------+----------------+----+------------+ ----+----+----+---------+--------+--------+ | | 0 | Flat 39 | Westham House | Forth Drive | | Birmingham | | | | B37 6PS | 417842 | 287569 | | | 0 | Flat 39 | Wedgewood House | Forth Drive | | Birmingham | | | | B37 6PU | 417908 | 287604 | | | 0 | Flat 39 | Mansfield House | Woodlands Way | | Birmingham | | | | B37 6RT | 418528 | 287140 | | | 0 | Flat 39 | Wadham House | Woodlands Way | | Birmingham | | | | B37 6RU | 418515 | 287185 | | | 0 | Flat 39 | Selwyn House | Waterson Croft | | Birmingham | | | | B37 6TT | 418777 | 287260 | +------+----+---------+-----------------+----------------+----+------------+ ----+----+----+---------+--------+--------+ 5 rows in set (7.11 sec) mysql> select * from ap023 where sb like '%39%' limit 900,5; +------+----+---------+-----------------+----------------+----+------------+ ----+----+----+---------+--------+--------+ | orgn | bn | sb | bd | tn | dr | pt | dl | dd | cn | pc | xcoord | ycoord | +------+----+---------+-----------------+----------------+----+------------+ ----+----+----+---------+--------+--------+ | | 0 | Flat 39 | Westham House | Forth Drive | | Birmingham | | | | B37 6PS | 417842 | 287569 | | | 0 | Flat 39 | Wedgewood House | Forth Drive | | Birmingham | | | | B37 6PU | 417908 | 287604 | | | 0 | Flat 39 | Mansfield House | Woodlands Way | | Birmingham | | | | B37 6RT | 418528 | 287140 | | | 0 | Flat 39 | Wadham House | Woodlands Way | | Birmingham | | | | B37 6RU | 418515 | 287185 | | | 0 | Flat 39 | Selwyn House | Waterson Croft | | Birmingham | | | | B37 6TT | 418777 | 287260 | +------+----+---------+-----------------+----------------+----+------------+ ----+----+----+---------+--------+--------+ 5 rows in set (7.22 sec) --------------------------------------------------------------------- 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
