Re: Oracle performance with Microsoft Project

Jim Kennedy wrote:

>"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?
>>
>>
>Do they use bind variables?
>Jim
>
>
>
>

Remember all that stuff in the news and in the anti-trust suit about hidden APIs? ;-)

If you need help email me off-line (address below my signature). I can get you contact information for the person that handled the Oracle to Project Managment stuff at Boeing. And I'm sure their volumes were many times yours.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)