1

MySQL Indexing Considerations Of Implementing A Priority Field In Your Application


Posted by Artem Russakovskii on March 18th, 2009 in Databases, Linux, MySQL, Programming

Updated: June 24th, 2020

Introduction

If you, like me, are building or thinking of implementing a MySQL-powered application that has any need for prioritizing selecting certain data over other data, this article is for you.

Example

As a real world example, consider a queue-like video processing system. Your application receives new videos and processes them. The volume of incoming videos can at times be higher than the processing rate because the process is CPU bound, so occasionally a pretty long queue may form. You will try to process them as fast as you can but…

Note that I am using a queue here, so the next item to be processed is a result of sorting by some sort of field in a ascending order

…

Read the rest of this article »

5

Have You Pre-Ordered Starcraft 2 Yet? No? Here’s What You Need To Know


Posted by Artem Russakovskii on March 8th, 2009 in Awesomeness, Gaming, My Favorites

Updated: March 10th, 2009

image I could not be more excited about the upcoming Starcraft 2. Announced in 2008, a whopping 10 years after the first Starcraft release, the news sent shockwaves through millions of Starcraft fans, myself included.

I’ve been watching and anxiously awaiting the release and, while the final release date is unknown at this point (I'll update the post when it is announced), I’ve assembled a list of current Starcraft 2 facts, summarized as bullet points.

But before I get into that, here’s the most important part you need to know to be able to get your hands on the game right after it’s released and play online ($49):