Re: Random Unique ID

On Fri, 2007-03-23 at 09:15 +0100, Németh Zoltán wrote: > // method 2 > $time = microtime(TRUE); > for ($i = 1; $i <= 5000; $i++) { > $done = FALSE; > while (!$done) { > $id = md5((microtime(TRUE) * (rand(1,1000) / 100))); > $sql = "INSERT INTO idtest (id,cnt) VALUES ('$id', $i)"; > $result = mysql_query($sql); > if ($result) { $done = TRUE; } > } > } > $end = microtime(TRUE) - $time; > echo "method 2 time: " . $end . "<br>"; One of the problems with the above style is that if the query fails for some other reason (typo, no permissions, database temporarily unavailable, etc) the code will run indefinitely (or until it gets killed for too much time). That's a very dirty way to manage failed inserts due to dupes. Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------'