How to create random, but unique IDs?

[eluser]n0xie[/eluser]
You could of course generate a list of available id's as a cronjob, and place them in a temp table/memory/file/xml/whatever. It depends on how many new id's you think you'll need on a day to day basis. You could even just store them in memory as an array and just remove any used id from that array, then schedule a background task to repopulate the array with new id's.

This would make new id's instantly available, plus it would save you database lookups every time you need a new id.