title: Date range queries in Azure Table storage
body: <p>Hello following on from my question: <a href="https://stackoverflow.com/questions/21149087/windows-azure-table-access-latency-partition-keys-and-row-keys-selection">Windows Azure table access latency Partition keys and row keys selection</a> about the way I have organised data in my Azure storage account. I have a table storage scheme designed to store info about entities.</p>
  
  <p>There are about 4000 - 5000 entities. There are 6 entity types and the types are roughly evenly distributed. so around 800'ish each.</p>
  
  <p>ParitionKey: entityType-Date</p>
  
  <p>Row key: entityId</p>
  
  <p>As the question details I have been sufferring latency issues where querying for multiple partitions seems to take quite a while. </p>
  
  <p>Essentially one possible solution would be to do a query of the following:</p>
  
  <p>PartitionKey > 'EntityType-Date' and PartitionKey &lt; EntityType-HighDate' and RowKey = 'EntityId'</p>
  
  <p>This does not seem to work in Window Azure Storage Explorer. It doesn't seem to recognize the greater than less than, which I'd kind of expect.</p>
  
  <p>My question is exactly how does less than, greater than work and would I be better splitting my entities out by table type. Thus my query would be? Or should I be pursuing a different approach?</p>
  
  <p>PartitionKey > LowDate and PartitionKey &lt; HighDate and RowKey = 'EntityId'</p>