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

Factual Questions
21

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).

22

[QUOTE=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).
[/QUOTE]

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…

23

[QUOTE=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
[/QUOTE]

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

24

[QUOTE=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).
[/QUOTE]

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.