Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

slow pass-through query, runs quick in sql server

tiesto (Programmer) (OP)
13 Dec 09 23:56
Hey all,

I'm having a strange problem with a particular pass-through query from Access 2003 to SQL Server Express 2005 suddenly running very slow. It's a stored procedure which I can get to run in about 5 seconds directly on SQL, but it takes at least 3 minutes to run the exact same query via a pass-through query in Access. The problem also started suddenly a few weeks ago, it was running from Access in about 6 seconds until then.

I have many other pass-through queries in the database which are fine and run at normal speed. I have tried creating a new pass-through and running the same query with the same result. The same thing happens on my test machine at home and all the workstations at my client. As far as I'm aware there have been no changes to drivers or versions of Access (they run a combination of 2000, 2003 and Runtime 2007 on their workstations, all having the same problem.)

Any ideas would be greatly appreciated!
 
lespaul (Programmer)
14 Dec 09 10:41
do you have an index on the table that is being queried?

Leslie

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close