Hi,

I have a need to extra a list of valid DTMF input from DB ( as it may sometimes chang). The way I would do it is to extract the list of valid DTMF from DB before session.answer(). When the caller enters the DTMF when the menu is played, I need to search to see if the input is within the the resultset. There are few ways that I can think of:

Option 1: Do a search query whenever the user enter the DTMF to check if it is valide.

Option 2: Traverse the resultset (setting cursor to beginning of the resultset) to see if the entered DTMF exists or not.

Option 3: Store the entire resultset into a hash table before playing the menu.

From the performance perspective, which one is better? Is there a better way to do it?

The problem is that I am already experience some delay when doing the first DB call to get the entire list of valid DTMF from DB. I just think further delay is not good.

Is there any good way to search for an element within a resultset?

Thank you in advance for your input.

Regards,
Pete