<div>
I recently answered this question for someone else, you can see the answer here:<br />
<br />
<a href="https://www.experts-exchange.com/questions/25016779/Good-way-of-generating-guaranteed-unique-ids.html" rel="ugc">https://www.experts-exchange.com/questions/25016779/Good-way-of-generating-guaranteed-unique-ids.html</a>
</div>


I recently answered this question for someone else, you can see the answer here:

https://www.experts-exchange.com/questions/25016779/Good-way-of-generating-guaranteed-unique-ids.html [https://www.experts-exchange.com/questions/25016779/Good-way-of-generating-guaranteed-unique-ids.html]

<div>
Would you say this type of ID would be better suited than say an actual UUID? Also, performance wise, this database will end up with 20m+ rows.
</div>


Would you say this type of ID would be better suited than say an actual UUID? Also, performance wise, this database will end up with 20m+ rows.

<div>
My solution generates numbers, so you can make the numbers as large as you want (within the constraints of MySQL), and numbers tend to be easier to work with. &nbsp;If this will be a primary key, it will be much easier to deal with than a string of letters and hyphens.<br />
<br />
I don't know for sure, but I suspect indexing (as is always done for keys) will be quicker using integers than for complex strings.<br />
<br />
Just make the maximum number about 5 orders of magnitude larger than the number of them that you expect to use.
</div>


My solution generates numbers, so you can make the numbers as large as you want (within the constraints of MySQL), and numbers tend to be easier to work with.  If this will be a primary key, it will be much easier to deal with than a string of letters and hyphens.

I don't know for sure, but I suspect indexing (as is always done for keys) will be quicker using integers than for complex strings.

Just make the maximum number about 5 orders of magnitude larger than the number of them that you expect to use.

<div>
<div class="content wysiwyg-content">
What's the best way to generate a UUID in PHP? Should it be pseudo random? or time based?<br />
<br />
The ID's will be used with mysql as a primary key. There will be a lot of inserts/updates on the table, as well as joins.<br />
<br />
The ID will also be used as a temporary session ID (e.g. passed in the URL), so auto increment would not be suitable.
</div>
</div>


What's the best way to generate a UUID in PHP? Should it be pseudo random? or time based?

The ID's will be used with mysql as a primary key. There will be a lot of inserts/updates on the table, as well as joins.

The ID will also be used as a temporary session ID (e.g. passed in the URL), so auto increment would not be suitable.

PHP UNIQUE ID's / UUID

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.