RE: iSeries Imaging (was: Help me Justify iSeries)

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

Paul,

w/o ordering. However, if I only got 21 rows from a million row table I
must have had a where clause. <G> Like I said, it was a "quick" select.
However, I've also run 21-way joins (yes 21) with sub-second results.

-Walden 


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
  


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of pnelson@xxxxxxxxxx
Sent: Friday, 27 May, 2005 14:37
To: Midrange Systems Technical Discussion
Subject: RE: iSeries Imaging (was: Help me Justify iSeries)


With or without ordering? With or without a where clause?
--

Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx




-----midrange-l-bounces@xxxxxxxxxxxx wrote: -----

To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
From: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Date: 05/27/2005 01:11PM
Subject: RE: iSeries Imaging (was: Help me Justify iSeries)

>So add scalability to your iSeries justification, Ron. How well will
>your Windows DB server scale past 10 million records?

And

>The MS database engine just sucks at large tables.

Um, really, that's news to the servers I have with millions of rows in a
table. A quick select on a million row table on a P4 2Ghz w/786meg off a
40 gig ide drive (test machine I have sitting here) returned 21 rows in
18ms.

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
 Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.