Re: Oracle performance with Microsoft Project

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 05 Sep 2003 08:12:18 -0500
Message-ID: <co2hlv8inrtb2rpa5i3ls4eiai3rtnibfb@4ax.com>

On Thu, 4 Sep 2003 14:09:16 -0400, "Thomas T" <T_at_T> wrote:

>"tom thayer" <tomthayer2_at_yahoo.com> wrote in message
<snip>
>I assume the SQL Server is running on a Microsoft system; are you using ODBC
>to connect to SQL Server?

I believe that to be a safe assumption. To my admittedly limited knowledge, SQL Server runs ONLY on MS platforms.
>

<snip>
>
>Also, were separate tablespaces used for indexes & tables? Or is everything
>in one tablespace?
>

Uh oh. Does the thread title "Oracle Myths" ring any bells?

>From my limited experience with SQL Server (mainly 6 and 7 and 2000),
>there's nothing to tune; it handles itself. Therefore an out-of-the-box SQL
>Server installation might run better initially then an out-of-the-box Oracle
>installation.
>

Quite possible. Oracle straight out of the box is notoriously poorly tuned.

>Just some wild guesses...
>
>-Thomas
>
Received on Fri Sep 05 2003 - 08:12:18 CDT