Re: who's got the biggest and the fastest?

we are creating a system to load 5 billion rows/day that is expected to be fully deployed 3rd quarter 2008. this is on oracle

Verisign has a custom built database that as of february/march 2007 did 36 billion executions/day. Its the backend DNS server for the internet. if you go www.google.com or whatever and its not cached you hit this database. They expect it to increase its volume by 20%/year for the indefinite future. it is written in C and all data is completely in memory.

I heard that Google has over 1 petabyte of memory for its search engine.

There is an particle accelerator being built at CERN in Europe. they are going to do an experiment sometime next year that will add 1 GB data/minute or a second or something like that. Its a custom made system. The only way I can think to do it is with straight serial writes and accept some data loss. Does anyone know more about this?

The absolute highest end systems push the edge of the technology available and will always need to be custom built specifically for their task.

• Original message ---------------------- From: Ian MacGregor <ian_at_slac.stanford.edu>
  > I know of an entity that adds 3,000,000,000 rows daily to a particular table
  > and has another which will soon surpass it. They run Oracle.
  >
  > Ian MacGregor
  >
  >
  >
  >
  >
  >
  

  attached mail follows:

  ---

  I know of an entity that adds 3,000,000,000 rows daily to a particular table and has another which will soon surpass it.  They run Oracle.  
  
  Ian MacGregor   
  
  
  
  
  
  

--
http://www.freelists.org/webpage/oracle-l