Re: Record IDs: Numeric or String??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Numeric IDs are probably a bit faster--although if properly indexed not
by much--plus you can use self-numbering columns with them.


Marco
-- 
------------
php|architect - The magazine for PHP Professionals
The first monthly worldwide  magazine dedicated to PHP programmer

Come visit us at http://www.phparch.com!

--- Begin Message ---
Is it more efficient to store record IDs in a MySQL database as an Integer
or a String? I like string IDs better because you can create meaningful
names, but, not sure if this means the DB has to work harder or not.

Thanks!


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--- End Message ---
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux