EXPLAIN EXTENDED

How to create fast database queries

My latest article on SQL in general: Things SQL needs: determining range cardinality. You're welcome to read and comment on it.

Archive for April 4th, 2009

Banning IP’s

Many webmasters and network service providers keep a database of IP addresses that are not allowed to access their resources.

Such a database can be efficiently queried using MySQL‘s spatial abilities.

Let’s create and fill the sample tables:
Read the rest of this entry »

Written by Quassnoi

April 4th, 2009 at 11:00 pm

Posted in MySQL