RE: 'Theoretical' SQL question

["Boling, David E." <BolingDE@xxxxxxxxxxxxxx>]

>>>It's a sad state of affairs, and no wonder why SQL Server simply out 
>>>performs both DB2 and Oracle...

I guess performance can be measured in different ways.

I can't comment on the speed of SQL Server vs. DB2 (or Oracle), but I do know 
that most vendors I come in contact with suggest that their application run on 
a stand alone SQL Server.  I've never had that experience on the iseries.  (My 
experience in general, is that you don't really want to run but one application 
of any kind on a windows server)

Sometimes this request is due to the unwillingness of vendors to integrate to 
an existing database (not necessarily an SQL Server problem, but still 
something I've never heard about on the iseries), but many times it's because 
they say that response time will be better if their application sits on the 
same server (or at least it will run better).

Now we're talking huge SQL server farms, multiple upgrades, and numerous other 
headaches.

>>> smaller tables (< 1m rows) but losses it's cookies big time after that...
>>>Large. Tens of millions of records.

I wouldn't necessarily think the number of records would be as important as the 
number of users and what it would take it to scale SQL Server to say 500, 1000, 
1500 users (in a real world environment, not some "super cluster"), which is 
not uncommon at all on an iseries.  Most of the times when I've heard of test 
with SQL Server it's emulated usage is for < 100 users (many times 5 - 10 
users).



David Boling
Rowan County Information Systems
(Voice) 704-633-5761
(Fax) 704-642-2083
Bolingde@xxxxxxxxxxxxxxxxx <mailto:Bolingde@xxxxxxxxxxxxxxxxx> 


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Hall, Philip
Sent: Thursday, January 20, 2005 4:41 PM
To: Midrange Systems Technical Discussion
Subject: RE: 'Theoretical' SQL question


Thanks for the info Kevin.

It's a sad state of affairs, and no wonder why SQL Server simply out performs 
both DB2 and Oracle...

--phil