How can execute query be delayed.
529448Jun 22 2007 — edited Jun 26 2007Hi:
I have an interesting little problem. In our application, we have a screen that our users have been trained to press and hold the key to execute the query in a block. When our users do this the forms performs an average of 12 queries for second. In a lot of cases our users hold the key for as long as 20 seconds resulting in well over 200 queries. To make things more interesting the application is used in our call center where approximately 50 people are answering the phone. Since they are all trained the same, this can add up at time to a lot of queries.
I was wondering if anybody has implemented a mechanism or algorithm by which under these conditions one can make the execute_query function to only execute once per lets say 5 seconds, thus reducing the number of queries significantly.
Any help would be appreciated.
Thanks,
Thomas