[wp-hackers] geocomments?

John Joseph Bachir jjb at ibiblio.org
Thu May 4 18:51:56 GMT 2006

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 


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

aim/yim/msn/jabber.org: johnjosephbachir

More information about the wp-hackers mailing list