Database join on varchar(32) Vs. bigint
| From: | Don Myers | Date: | Mon, 20 Oct 2003 13:23:11 +0000 |
| Subject: | Database join on varchar(32) Vs. bigint | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31147@lists.php.net to get a copy of this message | ||
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