Re: performance related
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.
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.