Database join on varchar(32) Vs. bigint

[Don Myers <allmylists@comcast.net>]

I was thinking about using

$productid = md5(uniqid(rand(), true));

To generate product id's in my PHP/MySql database (primary & indexed in
mysql) to make the product number a little more different then 1,2,3,4.

Of course these product ID will need to be used in many SQL joins is there a
noticable difference between using BIGINT Vs. varchar(32) in doing all of
those joins? Or because of the index it's not really a big difference (or no
difference at all?)

Don Myers

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php