MySQL Forums
Forum List  »  MyISAM

Re: performance related
Posted by: Edward Felch
Date: September 30, 2005 03:31PM

Having a key on a blob seems counter productive, MySQL would have to go through and compare every single blob against every other one in order to figure out if they were unique or not, comparing a lengthy string (or whatever you have in the blob) would intuitively take longer to search, sort, and insert than an index of an integer (with auto-increment) or some other simple data type.

Options: ReplyQuote


Subject
Views
Written By
Posted
2673
March 08, 2005 08:10AM
1838
April 27, 2005 04:26AM
Re: performance related
1877
September 30, 2005 03:31PM


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.