AnsweredAssumed Answered

Can we keep the ESS shadow tables updated?

Question asked by disabled_JohnWolff on May 7, 2015
Latest reply on May 10, 2015 by rrrichie

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,



Hamilton, NZ