B
blavine
Just switched over to 2007 from 2000. I have converted all my databases to
2007.
One job that I run (8 queries in a macro) used to take about 5-7 minutes on
2000 and now it takes about 50 minutes on 2007. The query links tables using
ODBC. Anyone have any ideas why the big difference in the time it is taking?
I also ran the job in "Compatability Mode" prior to converting the database
to 2007 with the same results. I was hoping that converting would solve the
problem. No such luck!
2007.
One job that I run (8 queries in a macro) used to take about 5-7 minutes on
2000 and now it takes about 50 minutes on 2007. The query links tables using
ODBC. Anyone have any ideas why the big difference in the time it is taking?
I also ran the job in "Compatability Mode" prior to converting the database
to 2007 with the same results. I was hoping that converting would solve the
problem. No such luck!