Re: Oracle performance with Microsoft Project

I worked with a MS Project 2000/Oracle environment a couple of years ago and it did not take much time with the product and MS support techs to figure out that this is an application that really only will scale when used with SQL Server. I bet you can spend one millon dollars buying more hardware and 6 months tuning your Oracle database backend without getting the environment to scale. The application is the problem and the vendor has minimal experience and interest in changing the app to work efficient Oracle.

Sten

tomthayer2_at_yahoo.com (tom thayer) wrote in message news:<3228903a.0309040520.72522c3_at_posting.google.com>...
> We are running Microsoft Project 2000 against tables in a database via
> ODBC. We have large projects and the performance is terrible when
> saving changes. MSP updates the entire project even if you only change
> a few things. The tables in the database are tied into a 3rd party CRM
> so using MPP files is not an alternative. The database being used is
> Oracle on an HP-UX system with lots of memory. The database is on a
> different machine than MSP. The best save times we get are with the
> Oracle ODBC driver. Even though the save times are long, we note that
> if we use a SQL Server database (also on different machine), the save
> times are < 40% of the save times against Oracle. E.g, a save time
> that took 5 minutes on Oracle only took 2 minutes on SQL Server, or 20
> minutes on Oracle only took 5 minutes on SQL Server. We have done
> performance tuning and looked at Oracle Performance Manager and TOP
> SQL and see that the sql is optimized. Why is the SQL Server path so
> much faster than the Oracle path here?
Received on Fri Sep 05 2003 - 16:31:40 CDT