title: Cassandra C# Driver - SELECT Statement Execution Slow
body: <p>I'm running a 3-node Cassandra 3.0.0 cluster running on AWS EC2 i3.large instances and I've been playing around with using the C# driver for Cassandra.  Executing the following query (which is very simple) takes approximately 300 ms (to scan the single partition and return the top 100 rows).</p>
  
  <p><code>var rs = session.Execute("SELECT col1, col6, col7 FROM breadcrumbs WHERE col1='samplepk' LIMIT 100;");</code></p>
  
  <p>My data model is:</p>
  
  <p>Column 1 = a 13-character string</p>
  
  <p>Column 2 = a 23-character string</p>
  
  <p>Column 3 = a date/time timestamp</p>
  
  <p>Column 4 = a 4-digit integer</p>
  
  <p>Column 5 = a 3 digit integer</p>
  
  <p>Column 6 = a latitude value</p>
  
  <p>Column 7 = a longitude value</p>
  
  <p>Column 8 = a 15-digit double</p>
  
  <p>Column 9 = a 15-digit double</p>
  
  <p>I defined my primary key as Col1, col2.</p>
  
  <p>My C# driver code is as follows:</p>
  
  <pre><code>Cluster cluster = Cluster.Builder().AddContactPoint(~~~~~IP Here~~~~).Build();
          ISession session = cluster.Connect(~~~keyspacename~~~);
          long ticks = DateTime.Now.Ticks;
          var rs = session.Execute("SELECT col2, col6, col7 FROM breadcrumbs WHERE partitionkey=~targetkey~ LIMIT 100;");
          Console.WriteLine((DateTime.Now.Ticks - ticks)/Math.Pow(10,4)+" ms");
          Console.ReadKey();
  </code></pre>
  
  <p>Is that abnormally slow or are my expectations too high?  If it is slow, does anyone have any ideas about what's causing it?</p>
  
  <p>If I forgot to provide any pertinent details, please leave a comment :) .</p>
  
  <p>Thanks in advance.</p>