unique_id() - can be faster?

1234homie · Post by **1234homie** » Sat Jul 30, 2011 9:03 pm

unique_id() need 2 queries to execute for get pseudo rand seed. I think it can be done with one query to config table but I don't know if its still secure so.. I've updated this funcation to something like this:

Code: Select all

removed ;D

My question is, It's still secure?

Oleg · Post by **Oleg** » Sat Jul 30, 2011 9:33 pm

On unix systems you can simply read data from /dev/random and hash it.

1234homie · Post by **1234homie** » Sat Jul 30, 2011 9:54 pm

Oleg wrote:On unix systems you can simply read data from /dev/random and hash it. wątyk

Im on windows

EDIT I've been searching for an alternative. thanks ;]

Oleg · Post by **Oleg** » Sun Jul 31, 2011 4:10 am

If you are concerned with database latency you can write a stored procedure that would perform computation(s) inside mysql with a single roundtrip.

It's a little too late on a Saturday for me to be able to comment on security of your proposed solution, but it does certainly not appear to be as strong as a /dev/random read just based on the functions you are using.

advertisements