echo "Keys are now populated<br/>";
echo "<br/>";
echo "<br/>";
echo "Finally search through all redis keys using <br/>";
echo " the primary wildcard:\"user\" <br/>";
echo " and then search through those results using:<br/>";
echo " 1.) the secondary wildcard: \"*:address\" <br/>";
echo " 2.) the secondary wildcard: \"*:payment\" <br/>";
echo " 3.) non matching stil match the primary wildcard <br/>";
echo "<br/>";
echo "The 3 results will be normalised into the tables:<br/>";
echo " 1.) user_address<br/>";
echo " 2.) user_payment<br/>";
echo " 3.) user<br/>";
echo "<br/>";
$redisql->normalize("user", "address,payment");
echo "<br/>";
echo "<br/>";
$redisql->select("user.pk,user.name,user.status,user_address.city,user_address.street,user_address.pk,user_address.zipcode", "user,user_address", "user.pk=user_address.pk AND user.pk BETWEEN 1 AND 5");
echo "<br/>";
echo "<br/>";
echo "If pure lookup speed of a SINGLE column is the dominant use case<br/>";
echo "We can now denorm the Redisql tables into redis hash-tables<br/>";
echo "which are faster for this use-case<br/>";
echo "<br/>";
echo "denorm user \\user:*\\<br/>";
$redisql->denormalize("user", 'user:*');
echo "HGETALL user:1<br/>";
print_r($redisql->hgetall("user:1"));
echo "<br/>";
echo "denorm user \\user:*:payment\\<br/>";
