On Wed, Mar 5, 2014 at 9:29 AM, big stone <[email protected]> wrote:
> Timing updates with Mysql 5.6.16 > MySQL does very well on query 8 which is a repeat of query 6. This might be because MySQL implements a query cache. It remembers the result of each query and if that query occurs again, without an intervening INSERT, DELETE, or UPDATE on one of the tables used by the query, just echos the previous answer. I think it would be interesting to do a single simple INSERT, DELETE, or UPDATE on the FEC table after test 8, then repeat the same query again, to see if MySQL is able to maintain the spectacular performance of test 8. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
