Project 2002 "open" performance via ODBC

P

Peter Alfvin

We've just started the migration from Project 98 in our
department and have noticed that the performance of
opening a project through ODBC/Oracle, which was already
relatively poor at around 15secs/file has jumped to around
1min/file. Effectively all of this time is consumed prior
to the "gas gauge" appearing and seems to be largely
related to the file itself. Opening a project through a
file is essentially instantaneous.

I've looked at the ODBC log and there are hundreds of
calls in there, but since there is no timing in the log,
I'm not sure if there any big delays or just a lot of
little ones.

Is anyone aware of any differences between 98 and 2002
that would account for this 4x difference? One other
important point is that the time for 2002 to open a 98
file through ODBC/Oracle is closer to the 15 secs, so it
suggests that the 4x difference may be related to the
structures of the 2002 tables vs. the 98 tables.

Thanks in advance for any "leads".

Pete Alfvin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top