Thank you, Scott! I tried running the same query after reboot and back-to-back, it was taking less time in both the cases. It means the problem is something else.
Can there be a reason which is more hardware/operating system specific and due to which the behavior is not uniform? Preetika On Mon, Mar 21, 2011 at 9:06 AM, Scott Ribe <scott_r...@elevated-dev.com>wrote: > On Mar 21, 2011, at 9:55 AM, preetika tyagi wrote: > > > For example, if A is 15 minutes, then B is 1.5 hrs. > > Well, considering that random disk access is on the order of 10,000 times > slower than RAM... > > But you can answer the question yourself by comparing the query run against > cold caches (after a reboot, or various command-line tricks to purge cache) > vs against warm caches (twice back-to-back). > > -- > Scott Ribe > scott_r...@elevated-dev.com > http://www.elevated-dev.com/ > (303) 722-0567 voice > > > > >
