SQL experts: Is count(*) or count(1) better?

[Arnold_Winkelried]

Pikers! The database at the Stanford Linear Accelerator Center’s database for their BaBar project was 2 petabytes in size, the last I heard (third quarter 2007).

[Jragon]

@Arnold Winkelried

Pikers! The database at the Stanford Linear Accelerator Center’s database for their BaBar project was 2 petabytes in size, the last I heard (third quarter 2007).

Bah it’s not a real database until it’s at LEAST A(g[sub]64[/sub],g[sub]64[/sub]) Yottobytes.

Well SOMEONE had to go all “I manage multiple universes for a hobby” eventually…

[Dervorin]

@susan_foster

Are we playing whose data set is bigger? 'Cause the one I am responsible for gets 40-60 million records a day. At one time we were up to 100 million a day. And each record is a couple hundred fields long.

Do I win?

Susan

Well, you certainly beat me. It’s not how big it is, though; it’s what you do with it.

[Dervorin]

@Arnold Winkelried

Pikers! The database at the Stanford Linear Accelerator Center’s database for their BaBar project was 2 petabytes in size, the last I heard (third quarter 2007).

Bah! If we’re talking particle accelerators, then the LHC is expected to generate about 10 petabytes per year. SLAC will need to, well, be a lot less slack.