We've implemented an integration of product data for our web site using an ODBC connection to the server, but thanks to our slow rural broadband connection, both the updating of product info and the downloading of web orders is anything but speedy.
What I'm seeing is that it takes up to a minute before the shadow table of recent web orders get refreshed when we go to that layout. Once there, the information is imported into our local table promptly enough.
Latency times for our connection to the web server are extremely variable as you can see from these ping stats:
38 packets transmitted, 37 packets received, 2.6% packet loss
round-trip min/avg/max/stddev = 43.903/449.707/539.919/116.666 ms
Is there any way of keeping the shadow tables of web order_details and order_items refreshed?
Thanks in advance,