MySQL Forums
Forum List  »  Optimizer & Parser

Re: performance issue on simple table access via primary key
Posted by: Marek Podmaka
Date: March 12, 2008 09:44AM

I don't think it is a good idea to have tinyblob as PRIMARY key... And are you sure that first 255 chars of that tinyblob will always be unique?
String comparison is ALWAYS much slower than integers... So maybe also varchar/string indexes are much slower.
You can try adding int(11) auto_increment as primary key and normal index on keyval(255) and see if it will be any faster.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: performance issue on simple table access via primary key
2412
March 12, 2008 09:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.