First project is about creating unique indexes for blob and varchar in Aria, MyISAM storage engine. It will provide user a direct interface for creating index for blobs , varchars .By this way user can also have unique constraint for blobs and very long strings.Second project will optimize it further by reducing time complexity of equal query from O(log b n) to O(1). By doing this we can also reduce time complexity of distinct query for any storage engine from O(n*log(n)) to O(n).So innodb will also benefit from this project because it internally uses maria for finding distinct blob.



Sachin Setiya


  • serg