Making app more resilient over Wi-Fi
|
Jackson, Adam
Hi,
Some users of our app understandably need to use it over Wi-Fi. For the vast majority of the time it is OK. Occasionally there is a Wi-Fi drop-out and the user gets a network based database error and most of the time they need to restart the app to re-establish connection. Even more occasionally but more worryingly if the network drop-out happens in the middle of transaction there may be an incomplete transaction. Apart from a root and branch review of our transaction settings to solve/mitigate the incomplete transaction issue is there any thing we can do to make the app more resilient to Wi-Fi drop outs?
Magic xPa 2.5d
TIA
Adam
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it
from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Adam,
toggle quoted message
Show quoted text
What database on the backend? If you're using Btrieve ISAM then, over the years, I developed a number of strategies to eliminate the problem of lost updates, et al, that I'd be happy to share with you. One simple thing you can do would be to enable Pervasive Auto-Reconnect (PARC) on the server and on the wireless workstations. Depending on your situation, this alone may be enough to solve your lost connection issues. On the server:  On the workstation:  Ultimately, however, if you're going to operate mobile, wireless workstations, your FIRST priority should be to update your wireless infrastructure to be more robust with Network Controllers that pro-actively manages wireless sessions, most-importantly being able to pass active sessions between WAPs. Yes, such controllers and their mating WAPs are not cheap, but if you're going to run with the big dogs ... ;) Steven G. Blank
Ξ SGBlank Consulting On 10/12/2022 2:35 AM, Jackson, Adam
wrote:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Jackson, Adam
HI Steve,
Thanks, as always, for getting back to me on this. We are not longer on Pervasive (I should have included this on my original email -apologies). We use MSSQL Enterprise v15. Had a root around the properties I can see and cannot see any equivalent setting as the one you highlighted below. That said I am not DBA so most probably not privy to all settings. I would assume that a) there is an equivalent setting and b) that is turned on but who knows?
I will ask about the transferring of connections from node to node.
Adam
From: main@magicu-l.groups.io <main@magicu-l.groups.io>
On Behalf Of Steven Blank via groups.io
Sent: 12 October 2022 19:26 To: main@magicu-l.groups.io Subject: Re: [magicu-l] Making app more resilient over Wi-Fi
Adam, Steven G. Blank On 10/12/2022 2:35 AM, Jackson, Adam wrote:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
