0

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
3
Views
11 Years
Discussion Span
Last Post by Raju5725
0

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.

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.