I have large text (can be 60,000 chars or more) in a string and I have TEXT type field in my table.
I need to see if the text in the string is not already in the DB.
What is the best way to do this ?
What I do now is to take 10 pieces of the string:
from char 2 to 102, from char 350 to 450, from char 460 to 560 and so on, and connecting 10 SQL's to check that field.
The problem is that it takes 7 seconds...
Can I do it better ?