Member Avatar for Raju5725

Hi,

I am having a one BLOB field in my table. I want to compare one BLOB value of one row with BOLB value of another row. I mean I want eliminate duplicate rows using the BLOB value. for this I want to write a tool using VB.Net can someone helps me HOW efficiently and fast I can do this.

Thanks in advance

Raju

  • 2 Contributors
  • 2 Replies
  • 104 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by Raju5725
Member Avatar for plazmo

id say the easiest way to check for duped blobs is to compare there hashes. so if you want it to be fast, add a hash column to the table, then generate like a md5 hash when you insert it.

Member Avatar for Raju5725

Thanks for your message.

I am having large db like almost 50 crore records already with me, Do you want me to md5 hash on these or is there any other way to proceed to compare BLOB fields to find out dups in a efficient manner and fast to complete these as less time as possible.

Thanks
Raju

id say the easiest way to check for duped blobs is to compare there hashes. so if you want it to be fast, add a hash column to the table, then generate like a md5 hash when you insert it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.