query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: query

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    query

    why would multiple procesess of the same query enable it to run faster.

    I ran the query one it returned 300 lines ever 30 secs
    created another sesion of the query and it ran 1000 lines every sec

    Why is this?

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Because data is now in buffers for 2nd query?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width