Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Choosing a database for a DSS system (40-100G range)
Baloney yourself. MS doesn't have any TPC-D numbers because they cannot
make a respectable showing there! (Believe me if they could even come close
they would.) terraserver is a joke as an example of scalability -
scalability is not the ability to look up a single row in a table - that
ability has been around for decades. MS SQL 7 still reparses each and every
query and is a major bottleneck on large systems.
Jim
Michael wrote in message ...
>Go with NT + SQL server 7
>Balony its not big enough. I have in production several hundred gigabyte
>systems on SQL 6.5. 7 scales wonderfully.
>Also DTS in SQL 7 will give you all the tools you need to import your data.
>TCP-D's don't worry. They are being rewritten at this current time.
>The optimizer in SQL 7 has been completely rewritten. You will love the
>product.
>if you want to see some large database performance go to
>http://terraserver.microsoft.com.
>
>
>
>
>
>
Received on Fri Nov 06 1998 - 00:00:00 CST