title: Database for super-fast querying
body: <p>We have a 300 Gb+ data array we'd like to query as fast as possible. Traditional SQL databases (specifically, SQL Server) cannot handle this volume as effectively as we need (like, perform a <code>select</code> with 10-20 conditions in <code>where</code> clause in less than 10 sec), so I'm investigating other solutions for this problem.</p>
  
  <p>I've been reading about <a href="http://en.wikipedia.org/wiki/NoSQL" rel="noreferrer">NoSQL</a> and this whole thing looks promising, but I'd prefer to hear from those who have used it in real life.</p>
  
  <p>What can you suggest here?</p>
  
  <p><strong>EDIT</strong> to clarify what we're after.</p>
  
  <p>We're a company developing an app whereby users can search for tours and perform bookings of said tours, paying for them with their plastic cards. This whole thing can surely be Russia-specific, so bear with me.</p>
  
  <p>When a user logs on to the site, she is presented with a form similar to this:</p>
  
  <p><a href="http://queenbee.alponline.ru/searchform.png" rel="noreferrer">alt text http://queenbee.alponline.ru/searchform.png</a></p>
  
  <p>Here, user selects where she leaves from and where she goes to, dates, duration and all that.</p>
  
  <p>After hitting "Search" a request goes to our DB server, which, with cannot handle such load: queries include various kinds of parameters. Sharding doesn't work well either.</p>
  
  <p>So what I'm after is a some kind of a pseudo-database, which can do lightning fast queries.</p>