One Million

Question

One Million

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
October 18, 2016 at 9:07 pm

#313982

Comments posted to this topic are about the item One Million

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

David.Poole SSC Guru Points: 76000 More actions · Answer 1

What impresses me is when Teradata was formed, what they set out to do and when they achieved it! 1992!

I was installing 20mb Western Digital file cards into PCs and we couldn't imagine ever filling one of those! We still backed up to 1.44mb floppy disks. You probably booted from a floppy disk if you didn't have a hard drive and both Word and Multiplan (forerunner to Excel) would fit on a single floppy!

Teradata remains deeply impressive but they don't seem to shout about it

LinkedIn Profile

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 2

1 Mil is a pretty good number. When we look at Sentry we do see around that range write bytes on our Env.

On another note, will you be at the PASS this year?

-Roy

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

Roy Ernest (10/19/2016)
1 Mil is a pretty good number. When we look at Sentry we do see around that range write bytes on our Env.
On another note, will you be at the PASS this year?

Yes, see you there Roy. Looking forward to it.

Is your 1mm sustained or burst? Is this 1mm write bytes/sec? 1MB writes/sec?

Gary Varga SSC Guru Points: 82166 More actions · Answer 4

It seems a bit of an arbitrary number. One million. In some cases very impressive but then again in others not at all.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 5

I have a demo I gave in a recent precon (first precon... YAY!) that processed all 7 million rows (each row was about 1040 bytes wide) in a table in 4 seconds. It included the creation of 5 different aggregates based on 5 different temporal ranges, used 1 compared to the other 4 to come up with "percent of period" calculations, and then ranked the 4 resulting percentages... on my laptop! It's nothing special, either... just a little ol' I5 based system with 6GB of ram and no SSDs.

One of the other things that Ed Wagner (my co-presenter) and I taught was how to build million row test tables in seconds. While a million rows isn't really that big any more, the people that don't have a million rows to test with really appreciated it because, if it works on a million rows, it's going to work on something less. And, if you need to test against more than a million rows, the same techniques make it all easy and fast especially if you use "Minimal Logging" techniques to build the test tables.

Long live the "million row test table". 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

In the small state that I work in, 1 million of anything is a big number.