uniqid as Primary Key

[jl-arenas]

I'm defining tables with md5(uniqid(rand())) (varchar 32) as Primary Key instead integer auto_increment.

I pass this id's in URL.
product.php?id=asdirjksndfj34dkwrejr...
instead
product.php?id=3

So i do this for security reason.

Is this an important lost of efficiency in select query's ??

Thanks

Sorry for my bad english.

[Anon]

The performance shouldn't be the bottleneck for small databases with slightly load.

You can use the integer p.k. :

I think it's not a problem giving the integerid for authorized persons. But securing it with a secret-code, the id and a following hashcode should be sufficient

f.e.
product.php?id=7&hash=a78e9809....

creating $hash with md5($id."secret") and
comparing the code in the header of your script with the production of the encryption function