Hi guys,
I'm working on a VB6 application that connects to an Oracle DB. The application (which sits on a server in London)generates a sequence of random signal numbers which a customer has to quote every time they request a transaction to be processed. If the correct signal number from the sequence is quoted, the status of that number is changed to 'used'.There will be about 200 concurrent user and each user changes about 1000 numbers a day. The users are currently in London and Dublin.
The problem is as follows. The users want their screen to automatically update if another concurrent user changes a signal number. Is there an event that can be triggered serverside every time a user changes a signal number that will update other users screen? What would be the performance/network implication of this? Or would a better solution be to code a timer event which refreshes every user's screen say every 30 secs or so. Would appreciate your comments / suggestions.
Niyi
I'm working on a VB6 application that connects to an Oracle DB. The application (which sits on a server in London)generates a sequence of random signal numbers which a customer has to quote every time they request a transaction to be processed. If the correct signal number from the sequence is quoted, the status of that number is changed to 'used'.There will be about 200 concurrent user and each user changes about 1000 numbers a day. The users are currently in London and Dublin.
The problem is as follows. The users want their screen to automatically update if another concurrent user changes a signal number. Is there an event that can be triggered serverside every time a user changes a signal number that will update other users screen? What would be the performance/network implication of this? Or would a better solution be to code a timer event which refreshes every user's screen say every 30 secs or so. Would appreciate your comments / suggestions.
Niyi