Punit Jain wrote:We convert criteria's to XML because we have import/export of searches feature in our product, that is the reason we use xml and convert it to blob to store in separate column in database.
"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here
Winston Gutkowski wrote:Given your current setup, I presume that you can be pretty sure that you currently have duplicate searches in your database, which suggests to me that even if you add a checksum field, there will be a 1:many relationship between 'checksum' and 'search'. In addition, no checksum can ever guarantee uniqueness, it can only make it likely.
Winston Gutkowski wrote:Also: How do you currently key your searches? Date/time? Or some combination of "fields used"? Does the table you store them in even have a unique symbolic key (as opposed to an ID)?
Winston Gutkowski wrote:It strikes me that you want to adopt a new approach, but aren't willing to make many changes to the database.
Opportunity is missed by most people because it is dressed in overalls and looks like work - Edison. Tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
|