Hi, friends,
I have a need to convert a database table (just one field) into a hash table to improve search performance, and wonder if anyone has done that before. Does wM have any built-in functions, or you have to write a java service?
They do exist!
It’s a nice surprise that I came across Ray Moser’s article on “Date Storage”, which solved my problem!
“…data store provides an implementation of a key-value hash table”, as his article says. It’s fairly easy to create a flow service to build a hash table, and another flow service to search it.
Without it, I had to loop through my recordset 20,000+ times and make over 20,000 queries for data validation alone. Now I just need to do one query, add the field to the KEY of data storage, and perform search at a cost of O(1).