6/13/2023 0 Comments Azure tables query with timestamp![]() ![]() At one point we were also using it as a fast, centralised session store for PHP. ![]() I have a blog on the basics of working with Table Storage and how we optimise for performance too. This is the only index that exists and it's not possible to index on other fields so fast querying means clever use of the Partition Key and Row Key properties. Those properties are the Partition Key and the Row Key and are used to create a clustered index for fast querying. Table Storage is a key:value store and entities (rows) have no fixed schema beyond the system required properties (columns). Take a look at that post if you want to get an idea of how we did that but this post is going to focus on how we do ORDER BY, another operator not supported in Table Storage. This is another similar hack that I've used to give me the ability to order results based on a timestamp.įirst time around we needed to do LIKE queries that aren't supported by Table Storage so we came up with a nifty workaround: Hacking Azure Table Storage to do LIKE queries I recently wrote about a little hack we did with Azure Table Storage to give us functionality equivalent to a LIKE query in SQL, something not natively supported in Table Storage itself.
0 Comments
Leave a Reply. |