Tired of Theories:

I live in the abstract. Spend time on the potential, not the real.

Remember imagination is not reality. Fantasy is not tangible.

I make money off of ideas, theories, visions, predictions.

What I’d give for a little bit of reality sometimes…

Never mistake your footing before you jump.

But don’t forget to leap with both feet.

An efficient alternative to paging with SQL OFFSETs

Originally posted on Developer Resources:

Challenge

Running WordPress.com means having multimillion-record database tables. Tables which we often need to batch-query.

Provided we could hardly select (or update, etc) millions of records at once and expect speed, we commonly have to “page” our scripts to only handle a limited number of records at once, then move on to the next batch.

Classic, but inefficient, solution

The usual way of paging result sets in most SQL RDMS is to use the OFFSET option (or LIMIT [offset], [limit], which is the same).

1

But on a performance level, this means you’re asking your DB engine to figure out where to start from all on its own, every time. Which then means it must be aware of every record before the queried offset, because they could be different between queries (deletes, etc). So the higher your offset number, the longer the overall query will take.

Alternative solution

Instead, of…

View original 240 more words

Remembering El-Hajj Malik El-Shabazz

No historic figure had more of an impact on my young, learning teenage mind than El-Hajj Malik El-Shabazz.

El-Hajj Malik El-Shabazz
In memory of his political genius for human respect, dignity, and equality.
Never forget: it’s bigger than what they teach in their school books.

On this day in 1965, Malcolm X was assassinated at the Audubon Ballroom in Washington Heights, New York.

Son of a Baptist minister; New York City hustler; honor student; convicted criminal; powerful minister in the Nation of Islam; father and husband: Malcolm X transformed himself, time and again, in order to become one of the most feared, loved, and undeniably charismatic leaders of twentieth-century America.

No one better represents the tumultuous times of his generation.

Knowing Your Net Worth Can Help You Plan

Elijah:

How do you stack up?

Originally posted on Business & Money:

Your boss doesn’t know your value, right? But do you even know it? Most people have never taken the time to figure their net worth even though it’s a fairly simple calculation. Why not take stock now? The New Year is still full of promise.

Your net worth is what you’d have left after selling everything, paying the bills and settling all debts. Think of it as your liquidation value. The number is of keen interest to heirs trying to understand what will be theirs. But it’s useful for you as well. Calculated annually, your net worth provides the clearest picture of whether you are getting ahead. It helps gauge when you might retire and gives a roadmap to where you are losing or gaining value. That makes it easier to adjust and meet your goals.

Say, for example, your goal is to retire with $1 million. But during the…

View original 370 more words