RE: [PHP] MySQL Primary Keys
| From: | John W. Holmes | Date: | Fri, 23 May 2003 00:35:21 +0000 |
| Subject: | RE: [PHP] MySQL Primary Keys | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-148662@lists.php.net to get a copy of this message | ||
> I thought adding primary keys to a database was supposed to improve
speed.
> Why is it that PHP is accessing it slower with primary keys added into
my
> tables? Should I get rid of them or not?
Saying "adding primary keys" speeds up your database is like saying
"register globals off" makes your programs more secure. It's not a
matter of simply having them, it's a matter of what columns you have
them on and what your SQL queries are like. And... this is a question
better suited to a MySQL mailing list.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/