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 ---
- To: php-db@lists.php.net
- Subject: Record IDs: Numeric or String??
- From: Monty <monty3@hotmail.com>
- Date: Wed, 06 Nov 2002 17:50:23 -0500
- Delivered-to: mailing list php-db@lists.php.net
- User-agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.3
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
