[nzlug] Data processing.....

[Andras Farago]

  Hi guys,
  What software can you recommend to process a database/txt file/whatever with approx 20 million rows, 25 fields in each row?
  I need to perform only very simple queries like “SELECT a, Sum(b) FROM data GROUP BY a ORDER BY Sum(b) DESC;”.
  Another important option is the time, I can’t wait all day to get the result.
   
  Andrew
  

       
---------------------------------
How would you spend $50,000 to create a more sustainable environment in Australia?  Go to Yahoo!7 Answers and share your idea.