Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
katarina07
Starting Member
31 Posts |
 Posted - 2007-11-27 : 04:30:16
|
| Hi,I had some queries based on ODBC-linked tables in my Access database, and they were not really fast -so I rewrote them to pass-through queries (I also separated data extraction and the creation of calculated fields, first).I can measure how much it takes for each query to execute, and I dont understand why:1) a pass-through query itself takes 6 seconds to execute2) a make-table query which just should add the records of the pass-through query from step 1) takes up to 2 minutes to executeI also have to say, I mostly have this problem if I run the database before 10 a.m., after 10 a.m. also the make-table query performs well - approx 8 seconds. So may be it has something to do with the server side.But I would still like to know what is this caused by.ThanksKatarina |
|
|
|
|
|
Bad performance of MTQ based on PassThroughQuery