1. loiter99 New Member

   Hello,
   I am pulling records via ODBC from a SQL server 2000 into an Access 2000 database. If I pull directly from a table the 9,000 odd records are transferred in 2 seconds. If I pull the same data through a view, the data is collected in 6 seconds, but the transfer time is 90 seconds. Does anyone have an explaination?
   
   Thanks
   Jeff
   

   loiter99, Aug 15, 2005

   #2
2. satya Moderator

   Monitor the event with PROFILER and check the execution plan for that query.
   BTW are you using DTS?
   
   Satya SKJ
   Moderator
   http://www.SQL-Server-Performance.Com/forum
   This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

   satya, Aug 15, 2005

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in