Ariejan de Vroom ariejan

Consider the following query

SELECT "orders".* FROM "orders" 
WHERE "orders"."bid" = 't' 
AND "orders"."region_id" = 10000002 
AND "orders"."type_id" = 30259 
ORDER BY price DESC
LIMIT 1

From a table with about 2.5million rows, it returns this one result in about 1075ms.

	state_machine :state, initial: :concept do
	state :concept
	state :incomplete
	state :complete
	state :dismissed

	event :cancel do
	transition [:concept, :incomplete, :complete] => :dismissed
	end
	end

	@Override
	public void render(float delta) {
	// Clear screen
	Gdx.gl20.glViewport(0, 0, Gdx.graphics.getWidth(), Gdx.graphics.getHeight());
	Gdx.gl20.glClearColor(0f, 0f, 0.2f, 1f);
	Gdx.gl20.glClear(GL20.GL_COLOR_BUFFER_BIT \| GL20.GL_DEPTH_BUFFER_BIT);

	// Set camera position
	camera.position.set(new Vector3(player.getPosition().x, player.getPosition().y, 0));
	camera.update();

	let(:post) { create :post, body: "Blah en narf" }

	it "let's Kramdown do the heavy lifting" do
	kramdown = double
	kramdown.should_receive(:to_html)
	Kramdown::Document.should_receive(:new).with(post.body).and_return(kramdown)

	helper.markdown(post.body)
	end

	#! /bin/bash

	# /etc/init.d/gitlab

	# GITLAB
	# Maintainer: @randx
	# App Version: 3.0

	### BEGIN INIT INFO
	# Provides: gitlab

	class Reader
	has_many :memberships
	has_many :magazines, through: :memberships
	end

	class Membership
	belongs_to :reader
	belongs_to :magazine
	end

	public abstract class BlockType {
	public static byte VOID = 0;
	public static byte DIRT = 1;
	}

	AUTOMAKE_OPTIONS = foreign
	SUBDIRS = src

	public class Dog {
	public String bark() {
	return "WOOF!";
	}
	}