Re: Re: using UID in DB
| From: | Nathan Rixham | Date: | Wed, 31 Mar 2010 11:06:52 +0000 |
| Subject: | Re: Re: using UID in DB | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-303658@lists.php.net to get a copy of this message | ||
Tommy Pham wrote:
>
> As for spatial data types, I've never find much use for non scientific
> related. (example) If using point as a PK, if MySQL stores it the
> same way as PostgreSQL which is 16 bytes, how is that any different -
> performance wise - than using UUID and storing it as binary(16) for
> MySQL or uniqueidentifier (16 bytes) for PostgreSQL?
>
it's all about the indexing (R-Tree)
http://en.wikipedia.org/wiki/R-tree