Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Sacramento, CA
    Posts
    193
    Thanks
    3
    Thanked 1 Time in 1 Post

    Pass-Through Query vs SQL using From IN Clause

    I've been doing some performance testing of a pass-through query to a MYSQL database compared to an SQL statement using a From IN clause with the appropriate connection string. It appears using the IN clause is about 3 seconds longer than a pass-through query in creating and reading a record set regardless of the number of records. I've tried as few as 6000 records and as many as 250,000. My take away form this both methods run on the server, but the connection is 3 seconds faster with the pass-through.

    Appreciate your insights.

    Marty

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Pass through queries should always be faster, since they are run directly on the server and Access does not try to parse them or execute them. Is that a problem?
    Rui
    -------
    R4

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    I'm assuming when you said you were " testing of a pass-through query to a MYSQL database compared to an SQL statement " that the SQL statement was an Access query?

    If that is the case, then your "take-away" is wrong. The Access query does not run on the server, in runs on your workstation.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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