Without seeing some trace files to see the wait statistics and what it was
broken down as we won't know.
"tom thayer" <tomthayer2_at_yahoo.com> 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 Thu Sep 04 2003 - 11:14:56 CDT
