> > Can someone please explain? (no pun intended!) > > Because of the same strategy in both cases I assume you > see caching effects. > To check this out you have to measure the execution time > of both statement right after the restart of the db.
or run each statement twice and look at the runtime of the second run. The first run does all the necessary I/O and loads the cache and the second just uses the cache. Regards Christian -- #include <std_disclaimer.h> /* The opinions stated above are my own and not necessarily those of my employer. */ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
