[wp-hackers] geocomments?

[John Joseph Bachir]

On Fri, 14 Apr 2006, John Joseph Bachir wrote:

> So, the best way to optimize retrieving arbitrary columns when selecting 
> on an option_name is to make the option_name the primary key. Of course, 
> this contradicts with the general guideline of making a primary key 
> column as short as possible. But since this selection is by far the most 
> frequent, and joins on this table are rare or non-existant, I still 
> think this would be the best option.
>
> However I do not have extensive experience working with tables that use 
> non-numeric coulmns as their primary key so perhaps I am missing 
> something here.

I just came accross this really great thread that is all about primary 
keys:

   http://feedlounge.com/blog/2005/11/20/switched-to-postgresql/

AFAIK the space problems with non-numeric primary keys mentioned in the 
thread are only applicable to InnoDB.

John
----
aim/yim/msn/jabber.org: johnjosephbachir
713.494.2704
irc://irc.freenode.net/lyceum
http://lyceum.ibiblio.org/
http://blog.johnjosephbachir.org/